Copy the column - Paste it into WORD - then In Word select REPLACE. When
the REPLACE Menu pops up Click on the button that SAYS MORE - then
Select "SPECIAL" then Select any LETTER and it should enter ^$ in the
FIND Box - Leave the Replace Box empty and then hit Replace ALL
Then copy the column and insert it back into your EXCEL document.


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