View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Arceedee Arceedee is offline
external usenet poster
 
Posts: 96
Default 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