Hi famdamly,

Without going to the compexity of regular expressions, my Excel add-in
"inspector text" has two easy ways to get what you're asking for:

=itEXCLUDE(A1,"0","1","2","3","4","5","6","7","8", "9")

and

=itREPLACE(A1,"[0-9]","",,TRUE)

Both of them give these results to your examples:

label
item
label
r
p

Also, both of them remove all instances of all digits, for example they
would return "label" for "lable123", and "item" for "01i23t45e67m89".

Here are the function references for itEXCLUDE and itREPLACE:

http://precisioncalc.com/it/itEXCLUDE.html
http://precisioncalc.com/it/itSEARCH.html

You can download the free edition of inspector text from here, and use
it as long as you wish:

http://PrecisionCalc.com


Good Luck,

Greg Lovern
http://PrecisionCalc.com
More Power In Excel



famdamly wrote:
First of all thanks to everyone for the assistance.

Perhaps it would be easier to show an example of sample data and the
desired result.

Sample data Desired result


A1 label3 F1 label
A2 item5 F2 item
A3 label2 F3 label
A4 6r F4 r
A5 3p F5 p