Yes, the letters are always two characters long.
No, the numbers are not always sequential, there are gaps.
The largest number so far is 25, I don't think I'll ever have number larger
than 99. Thank you.

"Rick Rothstein (MVP - VB)" wrote:

Are the letters you are typing in **always** two characters long? If not,
what is the longest number of characters you can type in? Are the numbers to
be returned **always** sequential listed (that is, could there ever be
gaps... 01,02,05,06,etc. for example)? Finally, what is the largest number
that will be returned?

Rick


"KO" wrote in message
...
When I type in certain letters, I need them to be displayed as certain
numbers, i.e., MJ = 01, HS = 02, SE = 03, etc. I'm not very good with
formulas, so any help is appreciated. Thanks in advance! :)