formula help

[scrabtree23]

In "column A" in "Cells 1 and 2" I have the following
data: A1234 and B4321 respectively. I need to have a
formula to drag down "column B" that would convert the
letters to numbers as follows: A1234 would become 11234
and B4321 would become 24321. Help?

 

[Tom Ogilvy]

=((CODE(LEFT(A1))-64) & RIGHT(A1,LEN(A1)-1))*1

then drag fill down the column.