| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I merge columns in excel inclusive of content
I am trying to merge data from 3 different columns but haven't a clue how to
do it! HELP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I merge columns in excel inclusive of content
Hi Nigel,
You can concatenate the columns using the ampersand thus: =A1&B1&C1. If you want spaces between the data, do: =A1&" "&B1&" "&C1. Ewan. "Nigel" wrote: I am trying to merge data from 3 different columns but haven't a clue how to do it! HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
