Another way is to, in B1 (insert a blank column B if needed), use this
formula:
="\"&A1
copy down per Paul's instructions. Then copy col. B,
pastespecialvalues over col. A, delete col. B
TIP: Always save your work BEFORE trying anything new....
Good Luck
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=474129