Hi all, I am trying to create a simple codeword decryption tool that will help automate converting several 15 and 16 digit numbers from their encoded letters to their actual numbers. I would like it to also be able to distinguish between letters and numbers and if the value is a letter return the correlated number, if it is a number then simply return that number.

As an example if using

a n g l e r f i s h =
1 2 3 4 5 6 7 8 9 0

where each letter corresponds to a number value I would like to be able to decrypt "aglenfhishg4175 to 134527089034175.

I would also like to be able to enter the alphanumeric value in one single cell and have it displayed in another single cell.

Any ideas on the easiest way to do this, I would prefer a formula as I am not real familiar with VB but am willing to give it the college try with a little assistance.

Thanks to anyone who can help me crack the code on doing this the 'ol manual way. It gets old quick

Cheers,
TJ