| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| change a string of numbers in to number format | Excel Worksheet Functions | |||
| How can I count the number of times a letter repeats in a string? | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| How to change text string? | Excel Discussion (Misc queries) | |||
Linear Mode
