Right Justify and Save As TXT

[ericdv]

Hi All,
I am using Excel 2007. I need to right justify a column in a preformated spreadsheet. The column will contain either one or two characters. For example, it may contain a number 1, or it may contain the letters BV. When I right justify the column it looks fine in Excel, but when I try to save the workbook as a TXT file, the two character value ends up pushed to the right of the single character value. I have tried changing the format of the column from text to general to number to custom, etc, but with no success. I have also removed the merge cells value from alignment, but that does not work. I seem to have run out of ideas. Any help would be greatly appreciated.
Thanks!

 

[Andrew Poulsom]

Whe you save to a text file only the text is saved. No account is taken of the formatting. It sounds like you need to export to a fixed width file:

http://www.cpearson.com/excel/ExportFixedWidth.aspx

 

[ericdv]

That makes sense. I'll have to spend some time with this. Thank you, Andrew!