This is a follow-up to a previous post that was solved, but I need to add the ability to handle a 2nd alpha string, as in the example below. I have a list of values, represented by column A below. I'd like to help to generate formulas for rows B,C,D,E that will extract each alpha and each numeric portion of the value into separate columns, as in the image below.

Here is the previous post:
http://www.excelforum.com/showthread...t=#post4138955
I'm currently using the solution from XOR LX posted 07-20-2015, 02:48 PM, but it can not handle the 2nd alpha string. Any help would be greatly appreciated.

Note the occasional leading zeros that need to be retained.

Capture.JPG

Thanks,
Trevor