Roger missed something from the LEFT functions - try this:

=IF(LEFT(A1,1)="B",1,IF(LEFT(A1,1)="A",2,IF(LEFT(A 1,1)="G",3,"")))

or, if you are likely to have A levels as well as AS in the futu

=IF(LEFT(A1,1)="B",1,IF(LEFT(A1,2)="AS",2,IF(LEFT( A1,1)="G",3,"")))

Hope this helps.

Pete


sike11 via OfficeKB.com wrote:

Hi Roger,

Thanks for the help!
I tried this but it gave me an error "#VALUE". Any other ideas?

Regards,

Mary

Roger Govier wrote:
Hi

Rather than having to type the whole description of what is in cell A1,
you could just use the first character as in the formula below
Enter in A2
=IF(LEFT(A1)="B",1,IF(LEFT(A1="A",2,IF(LEFT(A1)=" G",3,"")))

Hi All,

[quoted text clipped - 23 lines]

Mary.

--
Message posted via http://www.officekb.com