Thanks Mike. I don't know why I didn't think of it this way.

"Mike H" wrote:

One way.

Create a tanle of airports and numbers similar to this
Col a Col B
ATL 1
BOS 2
OHR 3
CDG 4
GAT 5


Then if you airpoty code is in C1 theis formula returns its number

=VLOOKUP(C1,A1:B5,2,FALSE)

Mike


"Pete" wrote:

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