if there are always 9 characters with the three numbers in the middle
in B1 enter
=left(A1,3) & right (A1,3)
and in C1 enter
=Mid(A1,4,3)

if the format varies, it gets more complicated.

"º¼ÖÝÈË" wrote:

Letter of alphabet and numeral separation
If A1= asd123dsa, how to get the B1= asddsa, C1=123