save a column of text as a file

R

Rick Merrill

How do I select a column of data and save it as an external file ( say, col.txt)?

One more thing, is there a way to have blank entries automatically skipped?!
 
B

Bernard Liengme

1 Save the worksheet as an Excel file before doing anything!
2 Insert a new worksheet: Insert|Worksheet
3 Select and Copy the column to be saved
4 Move to A1 in new worksheet; use Paste but if the column has formulas use
Paste Special -> Values
5 Select column; use Data | AutoFilter; use auto filter to display
Non-Blanks
6 Copy and paste these non-blanks to column B
7 Delete column A
6 Use File | Save As and specify Type to be TXT (this will save only the
current worksheet)
best wishes
 
D

Dave Peterson

I'd copy the column
open NotePad
Paste there
save it from there.

(Apply Data|filter|autofilter to that column. Then show only the non-blanks and
do the copy|paste if you need to avoid the blanks.)
 
Top