"everything before last number in that text" I guess you mean including those numbers.
Try:
=TEXTBEFORE(A1,TEXTAFTER(A1,{0,1,2,3,4,5,6,7,8,9},-1),-1)