ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i copy data from online so it goes into separate cells (https://www.excelbanter.com/excel-discussion-misc-queries/253533-how-do-i-copy-data-online-so-goes-into-separate-cells.html)

pete8150

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

Arceedee

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



All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com