ASAP Utilities, a free Add-in available at
www.asap-utilities.com has
features that will allow you to strip out all numerical and symbol characters
leaving only the alpha characters...
hth
Vaya con Dios,
Chuck, CABGx3
"Arne Hegefors" wrote:
Hi! I have a spreadsheet that contains lots of rating info. the info look
like eg AAA, AA+, A, BBB-, Aa3 etc. now I am only intereseted in the letters
ie I want to have a worksheet function that cleans the data from the numbers
and the plus, minus signs. How can I do this? pls any help appreciated!