Thread: Split 10 alphanumerics into 3 cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Split 10 alphanumerics into 3 cells
Vic

Data - Text to Columns - Fixed width and set the breaks OK

Mike

"Vic" wrote:

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