consistent 4 digit number
also this just in case there would be no spaces between the numebrs and text. a typo i prefer say 1000the rest is text
=TRIM(RIGHT(A1,(LEN(A1)-4)))