Re: Convert Excel to text

[Tom Ogilvy]

make all your text a monospaced font like courier new and set your column
widths to the proper spacing. Then save as a space delimited file (fixed
width).

Or you could write code to loop through you cells and build the proper
output strings.

http://support.microsoft.com/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications

Regards,
Tom Ogilvy

 

[Tom Ogilvy]

In my US English it is

Formatted Text (space delimited) (*.prn)

and is found pretty far down in the choices.


Regards,
Tom Ogilvy


Thanks a lot. For saving do you mean to save as 'tab
delimited' format.if i give column width as a 10 and then
my next column will start from 11th space in the text
file. Correct me if I am wrong

 

[Myrna Larson]

Tab delimited separates the fields with a tab character. If A1 requires 5 characters, the 6th
character in the file is the tab and the 7th is the 1st character from B1. You don't supply a
column width with the tab-delimited format.

 

[AJ]

Thanks a lot. I got it
AJ

-----Original Message-----
In my US English it is

Formatted Text (space delimited) (*.prn)

and is found pretty far down in the choices.


Regards,
Tom Ogilvy


Thanks a lot. For saving do you mean to save as 'tab
delimited' format.if i give column width as a 10 and then
my next column will start from 11th space in the text
file. Correct me if I am wrong / 11-


.

 

[DivyaS]

Hello, I have used your solution to convert an exel file to a text file but when I open the .prn file with notepad++, I find that not all columns present in the excel file are present in the text file.

Could you please help? I don't know if this has to do something with the features lost while saving the file.

Thanks,
Divya