Remove Contents from Cell After Last Letter...

[mlarson]

Hi all! I'm hoping you can help me with this question. Thanks in advance to anybody that helps!

I would like to remove contents of cells after the last letter.
For example, if a cell reads "a1b25f34" I would want it to become "a1b25f"... the "34" being the contents removed after the last letter "f".
Another example, if a cell reads "x376bf26ya1" I would want the result "x376bf26ya" with the "1" removed.

I hope I am explaining this question well! Thanks!

 

[Rick Rothstein]

Looks like it works even if not entered as an array-entered formula.

Assuming you mean my formula... on my XL2019 version, it does not work correctly for all possible values unless it is array-entered.

 

[mlarson]

Assuming you mean my formula... on my XL2019 version, it does not work correctly for all possible values unless it is array-entered.

Good to know, thank you!