Saving Into Columns ? "Robert11" <rgsros[ at ]notme.com> 25.09.2006 22:20:02 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

Re: Saving Into Columns ? "JoAnn Paules [MVP]" <jl_paules[ at ]hotNOSPAMmail.com> 25.09.2006 22:45:00 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" <rgsros[ at ]notme.com> wrote in message news:g6-dnc9HFJiNy4XYnZ2dnUVZ_vidnZ2d[ at ]comcast.com... [Quoted Text] > 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 > > >

RE: Saving Into Columns ? reno 27.09.2006 21:52:02 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. "Robert11" wrote: [Quoted Text] > 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 > > > >