Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't add a column to a specific file | Excel Worksheet Functions | |||
insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
How do I change *.CSV excel file to column seperated file? | Excel Discussion (Misc queries) | |||
Column in CSV file contains "03/04" should not display as 3-Apr -. | Excel Discussion (Misc queries) |