On Fri, 01 Sep 2006 21:06:06 +0100, David wrote:

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!


if you were going to use word you could have just replace *newline* with
", "

--
Steve (3)