When programming cash register department names, some manufactures require a series of two digit number keyboard entries for each letter used in a department name. Each department name could be as long as 8 digits with as many as 60 departments.

The programming manual will have a Alpha to number "key-grid" and the programmer has to translate by hand, then enter the 2 digit sequence into the Cash register i.e. to program CIGS / C always returns 23, I always returns 17, G always returns A3, S always returns 7G.

A1 A2 A3 A4 A5

1 CIGS (displayed) 23, 17 ,A3, 7G

I would like to simplify the process by entering each letter of the department name into a cell and have XL return a sequence of 2 digits.

So, can someone suggest a method or formula that will cause a pre-determined, 2 digit number to be displayed in an adjacet cell when a letter from A - Z is entered in a cell?

Thank-you

The programming manual will have a Alpha to number "key-grid" and the programmer has to translate by hand, then enter the 2 digit sequence into the Cash register i.e. to program CIGS / C always returns 23, I always returns 17, G always returns A3, S always returns 7G.

A1 A2 A3 A4 A5

1 CIGS (displayed) 23, 17 ,A3, 7G

I would like to simplify the process by entering each letter of the department name into a cell and have XL return a sequence of 2 digits.

So, can someone suggest a method or formula that will cause a pre-determined, 2 digit number to be displayed in an adjacet cell when a letter from A - Z is entered in a cell?

Thank-you

## Comment