ONE xls column to file?

  • Thread starter Thread starter destroy ducky
  • Start date Start date
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
 
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
Click to expand...


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


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