Assign a number to a cell

Hi

I am trying to assign a number to letters in a cell.
E.G
AB = 4
AC = 5
AD = 7
BT = 9

Lets say column A has the letters and i want column B to assign the number according to the letters.

Hope this is clear