Excel 2007 : Converting Letters to Numbers

Hi,

I am new here. I am using Microsoft Excel v2004 in Mac OS.. I need to determine the cost of our goods.

The problem is that the cost is not in numbers, but in a combination of letters and numbers in order to shroud the cost from strangers.

Could you help me write a very simple code that I could maintain and use for a very long while because I don't think I can manually decode each of the codes since there are more than 5000 of them.

The things to take note of are that you need to omit the first letter and the last number of each code because they are not part of the cost of the item. Then, I need to convert the remaining letters into numbers.

I have attached a file so you guys could get an idea.

P.S. For the code, I could private message or email you what letter corresponds to what number

Hope to hear from you guys soon.


-K