This is my first post here. Any help would greatly appreciated. I am trying to separate alpha characters, followed by numeric characters, followed by more alpha characters in 3 separate columns. There are no delimiters, and each set of characters can be different lengths. The alpha characters are always capitalized. I would like to do this with formulas.
Example:
A1=1C105
A2=9MP028
A3=25MJR338
A4=8PV4545

Thank you in advance for your help.
Trevor