In column G I have a list of names.
Some of the names have a number at the end & some don’t.
To remove the number at the end of the name I use:
=REPLACE(A2,SEARCH("[0-9]",A2,2),LEN(A2)-SEARCH("[0-9]",A2,2)," ")
This works fine with the names with numbers at the end but as soon as I get a name without a number I get an error
Libre office version 4.1.5.3
Calc