Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
Troubleshooting
Research
Professional Opinions
Ask a QuestionDid You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
troubleshooting Question
Excel: Split Text/Number String
asked on
I need to split a cell into three different cells - at the moment it is in the format AAAA111AA and I need to break it out into three cells showing (1) the string before the numeric piece starts - ie AAAA (2) the numeric string - ie 111 and (3) the piece after the numeric string - ie AA.
Note each of the three parts of the split string can be any length and "part (3)" will only have a value if "part (2)" exists.
ie I could have
"AAAAAA" is split to (1) AAAAAA (2) [blank] and (3) [blank]
"AA2314434" is split to (1) AA (2) 2314434 and (3) [blank]
"AABZEEH346678XXA" is split (1) AABZEEH (2) 346678 and (3) XXA
What is the formula for each of the cells (1),(2) and (3)?
Thanks
Note each of the three parts of the split string can be any length and "part (3)" will only have a value if "part (2)" exists.
ie I could have
"AAAAAA" is split to (1) AAAAAA (2) [blank] and (3) [blank]
"AA2314434" is split to (1) AA (2) 2314434 and (3) [blank]
"AABZEEH346678XXA" is split (1) AABZEEH (2) 346678 and (3) XXA
What is the formula for each of the cells (1),(2) and (3)?
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.