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

[TABLE="width: 500"]
<tbody>[TR]
[TD]AAAA3333MAX[/TD]
[TD]AAAA[/TD]
[TD]3333[/TD]
[TD]MAX[/TD]
[/TR]
[TR]
[TD]AAAA4444JUMP[/TD]
[TD]AAAA[/TD]
[TD]4444[/TD]
[TD]JUMP[/TD]
[/TR]
[TR]
[TD]BBBB55553159RMP[/TD]
[TD]BBBB[/TD]
[TD]5555[/TD]
[TD]3159RMP[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=MID(A1,9,100)

 

[Peter_SSs]

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

 

[PCL]

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