Split 1 col into 2 cols

[Betty Csehi]

I have the following in col A:
RMMX003245
TFM127854

I want cols B and C to contain the split info from col A:

Col B Col C
RMMX 003245
TFM 127854

I can do the =right and =left formula, but the problem is that, while there
will always be 6 numbers, there will not always be the same number of
letters. However, there will always be at least 1 letter and no more than 4
letters. Can someone tell me how to do this?

Thanks!

 

[JW]

Col B
=LEFT(H2,LEN(H2)-6)

Col C
=RIGHT(H2,6)

 

[JW]

Meant to change the references to column A.
Col B
=LEFT(A2,LEN(A2)-6)

Col C
=RIGHT(A2,6)

 

[Betty Csehi]

Thanks for the help. I do appreciate it!

Col B
=LEFT(H2,LEN(H2)-6)

Col C
=RIGHT(H2,6)