View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Robert11 Robert11 is offline
external usenet poster
 
Posts: 30
Default 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