Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Saving Data Into Columns ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert11 - 25 Sep 2006 21:21 GMT
Hello:

I have copied the following data from a web page that has it listed
in three columns:

311.000     AM      STRATCOM primary
321.000     AM      STRATCOM secondary
243.000     AM      Distress/guard
However, as expected, if I just do a copy on these columns that I've
highlighted, it wants to put them all in a single column in Excel.

What I would like is to put the column data from the page I've copied into
three separate columns in Excel.

Then, to save it in .csv format.

Any way of doing this, please ?

Thanks,
Bob
RobertVA - 25 Sep 2006 23:50 GMT
> Hello:
>
[quoted text clipped - 16 lines]
> Thanks,
> Bob

I count five spaces between first and second column, six between second
and third.

Open text with Word or a similar application

Use replace function to change all occasions of six consecutive spaces
into five consecutive spaces.

Use same function to change all occasions of four consecutive spaces to
a comma.

You now have three comma separated columns to write to disk and import
into Excel!
Jim Reed - 26 Sep 2006 11:44 GMT
After you copy from the web site, go to Excel and click on Edit ... Paste Special.  Select "text" from the dialog box.

Then highlight the range (should already be selected) and click on Data .. Text to Columns.  Choose "delimited", then choose all of the delimited options and check the box for "treating consecutive delimiters as one".

This should work.

Signature


Hello:

I have copied the following data from a web page that has it listed
in three columns:

311.000     AM      STRATCOM primary
321.000     AM      STRATCOM secondary
243.000     AM      Distress/guard
However, as expected, if I just do a copy on these columns that I've
highlighted, it wants to put them all in a single column in Excel.

What I would like is to put the column data from the page I've copied into
three separate columns in Excel.

Then, to save it in .csv format.

Any way of doing this, please ?

Thanks,
Bob
Pete_UK - 26 Sep 2006 12:01 GMT
The problem with that is that "STRATCOM primary" would be split into
two columns at the space - better to use Find & Replace (CTRL-H) to
replace 6 spaces with a character not expected in the data, eg comma or
semi-colon or pipe "|", then again for five spaces using the same
replacement character, then use Data | Text-to-columns using this
character as the delimiter.

Hope this helps.

Pete

> After you copy from the web site, go to Excel and click on Edit ... Paste Special.  Select "text" from the dialog box.
>
[quoted text clipped - 60 lines]
>
> ------=_NextPart_000_007B_01C6E137.4E50B200--
Jim Reed - 26 Sep 2006 12:34 GMT
Good point.  :)

Signature


The problem with that is that "STRATCOM primary" would be split into
two columns at the space - better to use Find & Replace (CTRL-H) to
replace 6 spaces with a character not expected in the data, eg comma or
semi-colon or pipe "|", then again for five spaces using the same
replacement character, then use Data | Text-to-columns using this
character as the delimiter.

Hope this helps.

Pete

Jim Reed wrote:
> After you copy from the web site, go to Excel and click on Edit ... Paste Special.  Select "text" from the dialog box.
>
[quoted text clipped - 64 lines]
>
> ------=_NextPart_000_007B_01C6E137.4E50B200--
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.