Saving Data Into Columns ?

[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

 

[RobertVA]

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

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]

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

 

[Pete_UK]

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]

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