Excel Code

[A. Mart]

I am trying to put together a spread sheet that will allow me to type a
specific letter and a 9 digit code will appear once I enter the letter.

 

[Don Guillett]

One way would be to use a table
col a col b
a 123456789
b 23456789
and use VLOOKUP formulas