Thread: In excel how do i get from this 44345678912 to this 0345678912 us.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Twoways Twoways is offline
external usenet poster
  
Posts: 1
Default In excel how do i get from this 44345678912 to this 0345678912 us.
I have in column A list of numbers looking like this 44345678912 and i need
to place a zero in front of the number but also taking away the two fours, i
know the formula for adding the zero ="0" & [A1] but can anyone help with
removing the two fours or a quick way to doing one at a time?
Reply With QuoteReply With Quote