| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to combine the content from eg. 3 cells into a new cell
Hi
In colimn A cell 1, I have entered the number 100 In column B cell 1, I have entered the number 10 In column C cell 1, I have entered the number 1001 Then I want to combine this data into cell 1 in column D to show 100-10-1001 - How can I do this? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to combine the content from eg. 3 cells into a new cell
If all you want is the numbers from A1, B1 and C1 in D1 separated by
dashes... =A1&"-"&B1&"-"&C1 -- Rick (MVP - Excel) "Kammam" wrote in message ... Hi In colimn A cell 1, I have entered the number 100 In column B cell 1, I have entered the number 10 In column C cell 1, I have entered the number 1001 Then I want to combine this data into cell 1 in column D to show 100-10-1001 - How can I do this? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to combine the content from eg. 3 cells into a new cell
CONCATENATE() is the function to combine text strings.
Alternatively you can use teh ampersand & =A1&"-"&B1&"-"&C1 If this post helps click Yes --------------- Jacob Skaria "Kammam" wrote: Hi In colimn A cell 1, I have entered the number 100 In column B cell 1, I have entered the number 10 In column C cell 1, I have entered the number 1001 Then I want to combine this data into cell 1 in column D to show 100-10-1001 - How can I do this? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I randomly select cells regardless of cell content? | Excel Worksheet Functions | |||
| How to Combine Cells using Other Cell | Excel Worksheet Functions | |||
| change content of a given cell as different cells are indicated | Excel Worksheet Functions | |||
| insert cell content and shift cells down | Excel Worksheet Functions | |||
| Combining cell contents when there is content to combine | Excel Discussion (Misc queries) | |||
Linear Mode
