PC Review


Reply
Thread Tools Rate Thread

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

 
 
pete8150
Guest
Posts: n/a
 
      15th Jan 2010
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 With Quote
 
 
 
 
Arceedee
Guest
Posts: n/a
 
      15th Jan 2010
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to alphabetize data from separate cells within same row marketingchickie Microsoft Excel Worksheet Functions 2 30th Nov 2009 09:55 PM
Re: copy entire row of data from separate w/s RagDyer Microsoft Excel Misc 0 6th Jan 2007 01:03 AM
Re: copy entire row of data from separate w/s CLR Microsoft Excel Misc 0 6th Jan 2007 12:28 AM
Split data from one cell to two separate cells =?Utf-8?B?TWljaGVsZQ==?= Microsoft Excel Worksheet Functions 2 25th Oct 2005 09:27 PM
Which formula to separate data in one cell to two cells? Doug Microsoft Excel Worksheet Functions 3 29th Jun 2004 12:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:35 AM.