=LEFT(A1,MAX(INDEX(((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<65)+(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>90))*ROW(INDIRECT("1:"&LEN(A1))),0)))
Try this