how do i copy data from online so it goes into separate cells

P

pete8150

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
 
A

Arceedee

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating carriage return data into separate cells 2
Copy data from unlocked cells 3
Excel Data pastes into 2 cells not 1 1
How do i extract worksheet cells with the same contents? 1
referencing multiple cells when data is organised differently 1
How to split numeric result of a formula in a cell into 2 cells? 2
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Copying data from cells A1,B1,C1 on tab1 to tab2 1

Top