"KO" wrote:

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! :)

One way, custom format the range as 00 and use AutoReplace, Replace MJ with
1 et al.

Regards
Peter