How do i pull the letter or letters from a cell with number and letters?

[tonywatsonhelp]

Hi everyone,

Ok So Cell B2 contains a code that is "Numbers Letters Numbers" for example "12A6" or "1AR17"
there can be many number or just one and many letters or just 1, but always in the same order.

I need a formula to remove the Letters so I get "A" or "AR"

please help if you can

Thanks

Tony

 

[James006]

Hi,

Take a look at solution proposed by Firefly ...

https://www.mrexcel.com/forum/excel-questions/609885-horizontal-string-extract.html#post3023433

 

[tonywatsonhelp]

Thanks James,
I used the UDF
worked perfect

Tony

 

[James006]

You are welcome ...