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:

Professional Opinions
Ask a Question
Did 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

Avatar of doolinn
doolinnFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
8 Comments1 Solution853 ViewsLast Modified:
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)?


Avatar of Dave
DaveFlag of Australia image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answers