troubleshooting Question

Excel: Split Text/Number String

Avatar of doolinn
doolinnFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft ExcelMicrosoft ApplicationsMicrosoft Office
8 Comments2 Solutions853 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)?



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

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros