Left Function Question Help!
You seem to be allocating a sequential number depending on the first
letter of A1. This formula will do that for you:
=CODE(UPPER(A1))-64
This will allocate 1 for "A" and "a", 2 for "B" and "b", 3 for "C" and
"c" etc up to 26 for "Z" and "z".
Hope this helps.
Pete
On Aug 22, 1:04*am, James8309 wrote:
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
|