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