paste special as text on tabular data from a web site puts most of the
data in the first column. It no longer spreads the columns of pasted
data into its own excel columns

the tabular data I want to 'copy&paste' looks like this:

1) OGRODOWICZ MARK M47 6306 BROOKLYN NY 533 446 41 24:00 23:25
7:33 20:58

2) CHAO DUSTIN M35 3738 NEW YORK NY 534 447 155 24:02 23:47
7:40 23:16

The paste should put this data into 2 rows, 12 columns each. All data
is text.


--
GottaRun
------------------------------------------------------------------------
GottaRun's Profile: http://www.excelforum.com/member.php...o&userid=31297
View this thread: http://www.excelforum.com/showthread...hreadid=519190