Sorting into multiple columns if 3rd digit is letter or number

I have to split a number into multiple columns. The value of the column depends on its position in the original number.

Examples:
69B2:

69 - Relates to an error, is always the first two digits. Need in 1st column. (I can get this one with LEFT() or MID() function.)
B - Can be in 3rd or 4th position. It's a time stamp. Need it in 2nd column.
2 - If it's in the 4th position, like this one, it's a 12. It refers to a location. Need it in the 3rd column.

892A:

89 - Different error, but still same position. (I can get this part)
2 - With a number in the 3rd position, like this, it's a 2. Put into 3rd column
A - Can be in 3rd or 4th position. Timestamp. Put into 2nd column


The original column can have lots of combinations:
89C0
89B3
89B1
89A0
898B
898B

I'd like a result like:

[Error] [Time] [Location]


I've tried using:

Please Login or Register  to view this content.

If the 3rd digit is a number, then use it, otherwise use the 4th digit and add 10.

Thanks

Looks like that got it. I was just missing the VALUE function.

Thank You.