Thread: Split 10 alphanumerics into 3 cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
  
Posts: 117
Default Split 10 alphanumerics into 3 cells
What is the formula to split 10 alphanumerics into 3 cells?
I have A2 = 1067035C03
I need B2 = 1067, C2 = 035, D2 = C03
Thank you.
Reply With QuoteReply With Quote