Thread: Need a left pad formula method
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
  
Posts: 111
Default Need a left pad formula method
Hi,
Assuming the originals are in Column A and you want the padded version
in column B this should work (you may have to format both columns as
text)

=REPT("0",10-LEN(A1))&A1

HTH,
OJ

Reply With QuoteReply With Quote