ONE xls column to file?

D

destroy ducky

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
 
G

Gordon

destroy ducky said:
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.
 
G

Gordon

Gordon said:
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top