determine a classification of a mixed letter/number code field

**Jason210** · 06-22-2012, 01:24 PM

Here is what I am trying to accomplish
I have a field with codes like
H0008934
S0034213
H002711
B015612
Etc

What I am looking to do is have a formula that takes that field and if the field begins with an H, in another field it will spit out a specific text such as "Telaxian", and if it starts with a S or a B that field would say "Voyager"

If the numbers after the letter didn't change I could use a simple nested if statement but with the varying numbers after it, I'm uncertain how to proceed.

Thanks,

Jason

**dilipandey** · 06-22-2012, 01:57 PM

Hi Jason,

Welcome to the forum.

You can use the below formula:-

=IF(MID(A1,1,1)="h","Telaxian",IF(OR(MID(A1,1,1)="s",MID(A1,1,1)="b"),"Voyager",""))

Regards,
DILIPandey

<click on below 'star' if this helps>