![]() |
how do I save a column to a file (in ascii format)
I want to save a column of a spreadsheet as a file in text format. How do I
do this? Thanks |
Copy the column. Open Notepad. Paste. Save.
"joe" wrote: I want to save a column of a spreadsheet as a file in text format. How do I do this? Thanks |
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. I want to save a column of a spreadsheet as a file in text format. How do I do this? Thanks |
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 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. "joe" wrote: I want to save a column of a spreadsheet as a file in text format. How do I do this? Thanks |
All times are GMT +1. The time now is 12:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com