Hi, maybe it's my version of Excel (2010) but I get 0Australia1484 using the solution outlined.
If it's changed to
=MID(A4,2+MATCH(1,(CODE(MID(A4,ROW(A$1:INDEX(A:A,LEN(A4))),1))<58)*(CODE(MID(A4&"a",ROW(A$3:INDEX(A:A,LEN(A4)+1)),1))>57),0),LEN(A4))
I get what's expected.