Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge - columns
hi,
i have a list of data in columns. i would like to merge the data from certain adjacent cells into one cell...but it is important that none of the data is lost (as does occur when using 'merge' function) does anyone know of a macro/way of achieving this? i would be most grateful for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge - columns
Try CONCATENATE function
For example in E1: =CONCATENATE(A1,B1,C1,D1) will merge/join the contents of these cells together. To add spaces between value: =CONCATENATE(A1," ",B1," ",C1," ",D1) Is this what is required? "jeff" wrote: hi, i have a list of data in columns. i would like to merge the data from certain adjacent cells into one cell...but it is important that none of the data is lost (as does occur when using 'merge' function) does anyone know of a macro/way of achieving this? i would be most grateful for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
I want to merge two columns | New Users to Excel | |||
Columns | Excel Discussion (Misc queries) | |||
how do you merge two columns in excel | Excel Discussion (Misc queries) | |||
how do you merge two columns in excel | Excel Discussion (Misc queries) |