Change 3 letter text string to a number string
 

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

Change 3 letter text string to a number string
 

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

Change 3 letter text string to a number string
 

This sort of thing is usually done with the VLOOKUP, utilizing a separate
cell. If you are wanting to type in the "ATL" and have Excel automatically
change it to the "300", in the same cell, then that can be done with
macros.......

Vaya con Dios,
Chuck, CABGx3



"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

Change 3 letter text string to a number string
 

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