I am trying to set up a formula that allows the user to input cost of an item on a sales order in a company-used alpha code. For example, A=1 B=2 C=3 etc. Because that is too simple a code, the code is based on a word with ten non-repeating letters, such as BEACHFRONT, where B=1 E=2 A=3 C=4, etc. If an item costs $12.50, the code entered would be BEFT. I could have a separate column with the actual cost and hide it but I would like to have to only enter the cost code once, then have a formula that would convert those letters into their respective numeric values where I could then enter other formulas for figuring selling priced based on established margins.

Any help on how to do that?