Thank you so much !! worked perfectly ! saved me hours (days) of work .. (
19000 x 3 cells)


"Dave Peterson" wrote:

Can you use a formula in another cell?

=left(a1&rept(" ",15),15)

This will truncate the value in A1 if the length is greater than 15, too.


Melissa wrote:

Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

--

Dave Peterson