How to get remaining text or numbers

[Salamullah]

Hi Experts,

I have account codes in column A, I want to separate them as follows, I am facing difficulty to apply formula to get in last column which is not fixed, please help

I have applied in Column B =LEFT(A1,4) and Column C =MID(A1,5,4) but need formula in Column D to get remaining of Column B & C

AAAA3333MAX	AAAA	3333	MAX
AAAA4444JUMP	AAAA	4444	JUMP
BBBB55553159RMP	BBBB	5555	3159RMP

<tbody>
</tbody>

 

[Fluff]

How about
=MID(A1,9,100)

 

[Peter_SSs]

Another option ..
=REPLACE(A1,1,8,"")

 

[PCL]

See next formaula
=RIGHT(A1,LEN(A1)-8)