| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a number from different fields.
...as in ...
=B13*B14*B15*B16 Or =B13*B14*B15*BR1 "chzabel" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a number from different fields.
chzabel
try = b13 & "X" & b14 &"X" & B15 & "X" & B16 Hope this helps "chzabel" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a number from different fields.
Thank you Sandy that is just what I wanted it to be.
Charles "Sandy" wrote: chzabel try = b13 & "X" & b14 &"X" & B15 & "X" & B16 Hope this helps "chzabel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| Template Wizard - Number of fields | Excel Discussion (Misc queries) | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| Auto-Enter Text in Excel Fields | Excel Discussion (Misc queries) | |||
| Automatically creating the correct number of dated columns | Excel Discussion (Misc queries) | |||
Linear Mode
