Since there doesn't seem to be any obvious pattern to assigning numbers to letters, you are probably better off creating a lookup table and using a Vlookup() formula..


If you set up a table, say in column Y and Z, with column Y having the letters and column Y having the respective number, then you can use a formula in B, like:

=Vlookup(A1,Y:Z,2,0)