How do you save an excel file to be read as IBM-type text file ?

D

Dee Franklin

I currently have done a list of members to excel and need to covert it to an
ASCII fixed-field text file, also sometimes known as an IBM-type text file.
Could someone please help.
 
G

Gary L Brown

1) Highlight the entire worksheet by left-clicking on the box in the upper
left-hand corner of the worksheet. It is at the intersection of the columns
and rows heading. 'A' is immediately to the right of the box and '1' is
immediately below it.
2) Select 'Courier' as the font
3) Select FILE
4) Select SAVE AS
5) Change the SAVE AS TYPE to 'Formatted Text (Space delimited) (*.prn)
6) Select SAVE
7) Select OK
8) Select YES

HTH,
 
Top