This has been driving me crazy !!!
I have a list of countries with a number on the end (the number is always a single digit)
Ireland1
Uk3
Belgium6
What I am hoping for is a formula to remove the number and just return the text, Ireland, Uk etc. There is no space after the country.
Thanks
Arts
I have a list of countries with a number on the end (the number is always a single digit)
Ireland1
Uk3
Belgium6
What I am hoping for is a formula to remove the number and just return the text, Ireland, Uk etc. There is no space after the country.
Thanks
Arts