Change Text to a number

[Guest]

I am trying to see if there is a way to change text entered into a cell into
a number based on the text entered. As an example, an airport code of MSP
would need to be changed to a store number 510. Is there a way to do this in
Excel 2000? There are about 25 codes that could be entered and of course 25
numbers.

Any suggestions would be appreciated.

 

[Debra Dalgleish]

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You may be able to adapt this
to your workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under the data validation heading, look for 'Data Validation "Columns"