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
|