Copy the column - open a WORD Document - Paste into Word
Select the Column - then do a TABLE to TEXT.
You should have paragraph marks after each item - you might have to
"TURN-ON" view paragraph marks - the paragraph mark symbol is on the
"Standard" Toolbar.
Now go to REPLACE - then under the "MORE" - SPECIAL tab - select
paragraph mark - or type in the find box ^p - (use the number 6 key for
the ^ symbol and lower case p). Then do a replace - then in the replace
box you can enter whatever you want or leave it blank. Everything will
go to 1 line.
Copy and paste back to excel.
Easiest way I know of doing it.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=516393