Me thinks there must be a better way of importing the data :)


Steve



On Fri, 01 Sep 2006 15:34:21 +0100, Pete_UK wrote:

That means you would want to combine about 323 cells into each
composite cell, and with a comma between each postcode (with an average
length of 7 characters, say) this means you will have 2584 characters
in each combined cell.

Pete

David wrote:
...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