Saving Into Columns ?
 

Hello:

I have copied the following data from a web page that has it listed
as shown below:

311.000 AM STRATCOM primary
321.000 AM STRATCOM secondary
243.000 AM Distress/guard

However, as expected, if I just do a copy (I can only highlight complete
rows)
on these columns that I've highlighted, it wants to put them all in a single
column in Excel.

In other words, 311.000, AM and Stratcom would be all in one cell.

What I would like is to put the column data from the page I've copied into
three separate columns in Excel. (311.000 in one cell, Am in the next cell
in the row, and Stratcom in the third cell in the row)

Then, to save the spreadsheet in .csv format.

Any way of doing this, please ?

Thanks,
Bob

Saving Into Columns ?
 

Try pasting in in as plain text or paste it into Word, convert to a table,
paste that into Excel.


--

JoAnn Paules
MVP Microsoft [Publisher]




"Robert11" wrote in message
...
Hello:

I have copied the following data from a web page that has it listed
as shown below:

311.000 AM STRATCOM primary
321.000 AM STRATCOM secondary
243.000 AM Distress/guard

However, as expected, if I just do a copy (I can only highlight complete
rows)
on these columns that I've highlighted, it wants to put them all in a
single column in Excel.

In other words, 311.000, AM and Stratcom would be all in one cell.

What I would like is to put the column data from the page I've copied into
three separate columns in Excel. (311.000 in one cell, Am in the next
cell in the row, and Stratcom in the third cell in the row)

Then, to save the spreadsheet in .csv format.

Any way of doing this, please ?

Thanks,
Bob

Saving Into Columns ?
 

Another alternative is to use DATATEXT to COLUMNS Wizard, this gives you the
option of using delimited or fixed length, in this case use fixed length,
which will "insert" column breaks into the data, you accept or move them as
you wish. Pretty intuitive and easy to use. Most data from websites can be
parsed this way.

"Robert11" wrote:

Hello:

I have copied the following data from a web page that has it listed
as shown below:

311.000 AM STRATCOM primary
321.000 AM STRATCOM secondary
243.000 AM Distress/guard

However, as expected, if I just do a copy (I can only highlight complete
rows)
on these columns that I've highlighted, it wants to put them all in a single
column in Excel.

In other words, 311.000, AM and Stratcom would be all in one cell.

What I would like is to put the column data from the page I've copied into
three separate columns in Excel. (311.000 in one cell, Am in the next cell
in the row, and Stratcom in the third cell in the row)

Then, to save the spreadsheet in .csv format.

Any way of doing this, please ?

Thanks,
Bob