Excel: Extract text only

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

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of May 06, 2015.

For more resources for Microsoft Excel