ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I save a column to a file (in ascii format) (https://www.excelbanter.com/excel-discussion-misc-queries/32495-how-do-i-save-column-file-ascii-format.html)

joe

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

IanRoy

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


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.

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

Thanks


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)

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.

"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