I believe you have wrongly interpreted my
question. You see the division is variable.
That is:
E1 will contain the numeric character
F1 will contain the alphabetic characters after it
G1 will contain the last numeric afterwards
Example:
D E F G
1 45XT48 45 XT 48
2 24XP5 24 XP 5
3 2TYE456 2 TYE 456
4

Therefore, the mid won't work