Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 83
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 83
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't add a column to a specific file Sue Excel Worksheet Functions 1 June 30th 08 05:03 PM
insert a blank column between each column in a data file Holly Excel Discussion (Misc queries) 1 October 31st 07 07:04 PM
need to export row as csv file with column e plus .bom as file name rod Excel Discussion (Misc queries) 5 November 2nd 06 03:38 AM
How do I change *.CSV excel file to column seperated file? Pankaj Excel Discussion (Misc queries) 2 July 5th 05 07:35 PM
Column in CSV file contains "03/04" should not display as 3-Apr -. The Palewhale Excel Discussion (Misc queries) 1 December 13th 04 04:31 AM


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"