Hi Everyone

I have this formulae in my cell;

=if(left(a1,1)="A",1,if(left(a1,1)="B",2,if(left(a 1,1)="C",
3,...................

and so on.

Question is.. I have to put in 'left(a1,1) each time I give
conditions. Is there other method of making this formulae simpler? so
I don't have to type left(a1,1) =

Thank you for your help in advance.


Regards


James