View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chzabel chzabel is offline
external usenet poster
 
Posts: 4
Default Creating a number from different fields.

I am trying to creat a number from different cells. I have 4 cells that are
in the following order:

B13 - 1.9
B14 - 40
B15 - 49
B16 - BR1

I want it to look like 1.9 x 40 x 49 x BR1 all in one cell. If anyone can
help me with this problem I would appreciate it.

Thanks,
Charles