Saving 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
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
 
Try pasting in in as plain text or paste it into Word, convert to a table,
paste that into Excel.
 
Another alternative is to use DATA>TEXT 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.
 
Back
Top