LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting different multiple columns rcg Excel Worksheet Functions 1 September 26th 06 05:58 PM
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
Merging two columns and keeping the data from both Stosh Excel Worksheet Functions 9 July 27th 06 06:48 PM
Data in narrow columns truncated when saving as DBF Ben Amada Excel Discussion (Misc queries) 2 October 11th 05 11:23 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"