| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting from web into Excel - Excel converts into mathmatical - how to prevent
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Prevent excel changing numbers data to dates. | Excel Discussion (Misc queries) | |||
| How do I prevent Excel from auto-correcting the date format? | Excel Discussion (Misc queries) | |||
| Excel won't open - pasting from Access | Excel Discussion (Misc queries) | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
Threaded Mode
