How do I specifly text lenth if the text is words instead of #'s
 

I need to have 14 characters in a line that contains words. How do I fill
the empty spaces with zeros?

How do I specifly text lenth if the text is words instead of #'s
 

=A1&REPT(0,14-LEN(A1))

--
Kind regards,

Niek Otten

"Kari Gray-Smith" <Kari wrote in
message ...
I need to have 14 characters in a line that contains words. How do I fill
the empty spaces with zeros?