I'm afraid you have to copy the data as is, however you can make a macro
to parse you data as you wish!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563559