merge - columns

J

jeff

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
 
T

Toppers

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?
 
Top