if it is pasting into a single column you can use the data..text to
columns menu to split it out.
use the options space delimited, the select all columns and state as
text then the function will leave all data as text.

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=523957