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
Our community of experts have been thoroughly vetted for their expertise and industry experience.