Remove only numeric value in the end of any string

[Admin]

Hi,

One way would be

=REPLACE(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"012 3465789")),LEN(A1),"")

[Rick Rothstein]

Here is another formula that you can use...

=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789"))-1)

NOTE: There appears to be a space in the list of digits in both my formula and the one Admin posted... there is no actual space in that text... for some reason, the text processor for this forum seems to randomly insert them for display only... if you copy/paste the formula, those spaces will not be copied (mainly because they are not really there).