I ended up:

creating a second column where each cell contained just a comma and a space.

creating a thrid column where the other two were combined.

Copying the whole third column and pasting it into Word.

Merging the relevant cells in Word

and then special pasting each merged cell contents as unformatted text.

Then each bit was cut and pasted back into each of the 9 cells.

Took all day but it's done!

--
David Kitching Msc. Msc.
Managing Director
Natural Deco Ltd.
The Manor
Manor Lane
Loxley
Warwickshire CV35 9JX
UK.

Tel: +44 (0) 1789 470040
Mob: +44 (0) 7799 118518
www.naturaldeco.co.uk

"David" wrote in message
...
Thats right...

As a matter of fact, I've just spent all day doing it manually.

--
David Kitching Msc. Msc.
Managing Director
Natural Deco Ltd.
The Manor
Manor Lane
Loxley
Warwickshire CV35 9JX
UK.

Tel: +44 (0) 1789 470040
Mob: +44 (0) 7799 118518
www.naturaldeco.co.uk

"Pete_UK" wrote in message
ups.com...
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