Hello,

I have a spreadsheet with a string of 3 letters (ATL) per cell, which
represent an airport. There are 24 different 3 letter combinations. I want
to change the 3 letter combination to a corresponding 3 number combination.

Example:
ATL = 300
BDL = 245

Is there a way to do this without modifying auto correct?


Thanks,

Pete