Right Justifing in Excel
 

I am wondering how to write a formula to right justify my data within a
column. I cannot use the formatting on the menu or toolbar because when I
save my document to a .txt file, it doesn't preserve the formatting. I am
looking to right justify data in a column that contains numbers (i.e.
10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my
file as a fixed length record text file. Thanks!
--
J Harris

Right Justifing in Excel
 

I'm not sure I understand the question. When XL data is saved to a .txt
file, only the values, not the formulas that calculate the values, are stored.

Dave
--
Brevity is the soul of wit.


"J Harris" wrote:

I am wondering how to write a formula to right justify my data within a
column. I cannot use the formatting on the menu or toolbar because when I
save my document to a .txt file, it doesn't preserve the formatting. I am
looking to right justify data in a column that contains numbers (i.e.
10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my
file as a fixed length record text file. Thanks!
--
J Harris

Right Justifing in Excel
 

Let's say your value is in cell A1 and you need it to take up 15 characters
in total

=rept(" ", 15-len(A1))&A1


"J Harris" wrote:

I am wondering how to write a formula to right justify my data within a
column. I cannot use the formatting on the menu or toolbar because when I
save my document to a .txt file, it doesn't preserve the formatting. I am
looking to right justify data in a column that contains numbers (i.e.
10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my
file as a fixed length record text file. Thanks!
--
J Harris

Right Justifing in Excel
 

That is exactly what I was looking for. Thanks for the help!
--
J Harris


"Duke Carey" wrote:

Let's say your value is in cell A1 and you need it to take up 15 characters
in total

=rept(" ", 15-len(A1))&A1


"J Harris" wrote:

I am wondering how to write a formula to right justify my data within a
column. I cannot use the formatting on the menu or toolbar because when I
save my document to a .txt file, it doesn't preserve the formatting. I am
looking to right justify data in a column that contains numbers (i.e.
10000.05) and numbers and letters combined (i.e. 10000.0p). I need to save my
file as a fixed length record text file. Thanks!
--
J Harris