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