| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i copy data from online so it goes into separate cells
In earlier excel products I could copy data (ezpass info) from online and
have it go into separate cells. With office 2007 - It only takes one line of the selected data and puts it into the first cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i copy data from online so it goes into separate cells
I don't know what ezpass info is but if you are trying to paste text into
Excel it is possible to have it in separate columns by using the Text to Columns feature in the Data tab. Paste the text into your s/s then select Text to Columns. This gives several options and depending on how the data is produced and how data is separated will depend on how you proceed. "pete8150" wrote: In earlier excel products I could copy data (ezpass info) from online and have it go into separate cells. With office 2007 - It only takes one line of the selected data and puts it into the first cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to alphabetize data from separate cells within same row | Excel Worksheet Functions | |||
| my data is bundled. how do I isolate in separate cells? | Excel Worksheet Functions | |||
| copy entire row of data from separate w/s | Excel Discussion (Misc queries) | |||
| Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
| Split data from one cell to two separate cells | Excel Worksheet Functions | |||
Linear Mode
