Thread: How do I specifly text lenth if the text is words instead of #'s
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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?


Reply With QuoteReply With Quote