text problem

[DennisN33]

Hi all

I have the following task I want carry out

In a cell I have the following initials and number combinations

DR7 or AZR20

as some names have middle names there are a mixture of 2 or three letters mixed with 1 or 2 numbers.

How can I extract the letters only to show DR and AZR only in the above example

thanks in advance

[Ron Coderre]

Will this work for you:

=LEFT(A1,2+ISERROR(FIND(MID(A1,3,1),"0123456789")))

Where the alphanumeric code is in cell A1.

If there can be a varied number of initials then this will work:

=LEFT(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},$A1&"0123456789",2))-1)
(Note: Commit that array formula by pressing [Ctrl]+[Shift]+[Enter])

Ron

[DennisN]

Thanks a million Ron

Thanks for your help and time

cheers
Dennis