Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting different multiple columns | Excel Worksheet Functions | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |