Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
joe
 
Posts: n/a
Default 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
  #2   Report Post  
IanRoy
 
Posts: n/a
Default

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

  #3   Report Post  
IanRoy
 
Posts: n/a
Default

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

  #4   Report Post  
abcd
 
Posts: n/a
Default

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)
  #5   Report Post  
IanRoy
 
Posts: n/a
Default

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

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
User cannot save excel file in workbook Justin@Martin Excel Worksheet Functions 0 May 16th 05 01:52 PM
How do I save format changes in a comma delimited file? mariam0673 Excel Worksheet Functions 2 March 1st 05 05:37 PM
Can't save new excel file twm7766 Excel Discussion (Misc queries) 3 February 1st 05 11:56 PM
Office 2003 - "autocomplete" in file | open or file | save no longer works Lanwench [MVP - Exchange] Excel Discussion (Misc queries) 4 January 12th 05 01:35 AM
format question when open csv file Jeff Excel Discussion (Misc queries) 1 December 1st 04 06:53 PM


All times are GMT +1. The time now is 06:04 PM.

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

About Us

"It's about Microsoft Excel"