Re: Convert Excel to text

  • Thread starter Thread starter Tom Ogilvy
  • Start date Start date
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
 
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.
 
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-


.
Click to expand...
 
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
 
Back
Top