Challenge: In A2, type a formula that will parse the string into {1;"A";2;"B";33;"CC";"4D";"5CCC";"1F";"6YY43F5";"9CD"} when you evaluate it in the formula bar with F9, as in the screenshot:

The Catch: there are some rules about the formula:

1)No UDF, only native functions

2)Cant use MID

(my solution uses 2 functions, and each of them are only used once!)