Hi All,

I have some data which is in text format. For ex.

abcd1
abcdes23
abgthygh456
abght6789
ab12
avhty190

need some formula which will remove only numeric value in the end of these text values.


Output will be like this

abcd
abcdes
abgthygh
abght
ab
avhty


Thanks in advance