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