Thread: make cell length always equal 10
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default make cell length always equal 10
This formula did it for me:
=IF(LEN(A1)=10,LEFT(A1,10),A1&REPT("0",10-LEN(A1)))
....where A1 contains the serial number. The formula uses the first ten
characters of the serial number if that serial num is 10 or more
characters in length; if it is less than 10 it fills in zeroes using
the REPT (repeat) formula.

Dave O

Reply With QuoteReply With Quote