....because I want all of the contents of every cell to be combined in to a
single cell, comma delimited. [and preferably with a space as well, after
each comma]. This is for putting the data into a postcode lokup database for
determining shipping costs. About 2900 codes are to be split over 9 cells.


"MartinW" wrote in message
...
Hi David,

I'm not sure I understand your problem.
Why do you want to merge the cells before you copy them?

Surely you can just highlight the entire column right click on it
and select copy, then open your new sheet right click in A1
and select paste.

Or am I missing something here?

HTH
Martin