Thread: I need to add spaces to the beginning of my texts which are numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Demetria Jones Demetria Jones is offline
external usenet poster
  
Posts: 1
Default I need to add spaces to the beginning of my texts which are numbers
example I have various account numbers as texts from 4 to 7 digits. I
need to make all account numbers 10 digits long with spaces at the
beginning. Another example....
_ _ _ 1234567.
Reply With QuoteReply With Quote