ONE xls column to file?
 

Please explain how to export one column in an excel document to CSV/

Assume multiple columns (one for email, one for home number, etc) for
import into any popular free ajaxian services. I want to be able to
both:


export number column to text file with one number per line

and


export number column to CSV

ONE xls column to file?
 

"destroy ducky" wrote in message
...
Please explain how to export one column in an excel document to CSV/

Assume multiple columns (one for email, one for home number, etc) for
import into any popular free ajaxian services. I want to be able to
both:


export number column to text file with one number per line

and


export number column to CSV



Select column. Right-click- copy. New Workbook. Click on cell at top of
column, right-click, select Paste. Save-As csv file.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

ONE xls column to file?
 

"Gordon" wrote in message
...
"destroy ducky" wrote in message
...
Please explain how to export one column in an excel document to CSV/

Assume multiple columns (one for email, one for home number, etc) for
import into any popular free ajaxian services. I want to be able to
both:


export number column to text file with one number per line

and


export number column to CSV



Select column. Right-click- copy. New Workbook. Click on cell at top of
column, right-click, select Paste. Save-As csv file.



You might have to do Paste Special-Values if the column contains formulae...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)