Get text from string after last number

[sharky12345]

Is there a quick way I can extract the text in a string after the last number?

My strings are all letters, then numbers, then letters again - the numbers always fall in the middle of the string, but I need the text at the end, excluding any spaces.

Is it possible please guys?

 

[Rick Rothstein]

Is there a quick way I can extract the text in a string after the last number?

My strings are all letters, then numbers, then letters again - the numbers always fall in the middle of the string, but I need the text at the end, excluding any spaces.

Is it possible please guys?

Are you really still using XL2016? If so, then I cannot help you as I only have XL365 here. However, if you do happen to have XL365 or XL2024, then this single formula will generate all of the text for the specified range...

=TEXTAFTER(A1:A3,SEQUENCE(10,,0),-1)

 

[Scott Huish]

I don't have that old of a version to test this, but maybe:
=MID(A1,MATCH(2,IF(ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),1,""))+1,100)