how do I save a column to a file (in ascii format)

J

joe

I want to save a column of a spreadsheet as a file in text format. How do I
do this?

Thanks
 
I

IanRoy

Just noticed your ascii requirement. Looked it up and found this:
"Plain text files normally use one of two types of character sets: ASCII or
ANSI. DOS uses ASCII (pronounced "ask-key"). ANSI ("an-see") is the character
set used by Windows. There are many variations and sub-sets but ASCII and
ANSI are virtually identical until you start using some extended characters
such as äèö. Sometimes the term ASCII file is used to describe any plain text
file."

Since Windows uses ANSI for text, I do not know how you would get the column
into ASCII within Windows. Sorry.
 
A

abcd

often the "ascii" name is used just to say "not in complex word format"
to mean "simple text"

if he means "ascii" in it's real meaning (not windows ANSI) then he
will need to use a "converter". Many text editors can do this. I do not
know on built in windows (as you said)
 
I

IanRoy

I think I may have found it. Paste the column into WordPad, save as "Text
Document - MS DOS Format. If the article I referenced was correct, that will
be ASCII.
 
Top