Saving Data Into Columns ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

Robert11

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
 
Robert11 said:
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
Click to expand...
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!
 
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.

--

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
 
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
 
Good point. :)

--

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
 
Back
Top