Separating text and numbers from a mixed code

Hello,

Need help to separate text and numbers from a alphanumeric code. the code could be in any order ( no first, no last, no in between etc).
Did try available solutions but yet far off from desirable outcome.

Ideally I was looking to get a formual based solution to the sample data enclosed here. I have been able to separate/solve part of it through text to col function but as it is, it will require an application of function everytime I have new data. A formula based solution could have helped permanently.

Will be very thankful if some body could help

regards