Pete, Just an FYI..
You say Roger "missed something", not sure but maybe you thought
it might be the 2nd parameter of the Left() function.. (anyway)

By Default if no 2nd parameter is given, 1 is assumed. Try it

In B1 enter:
=Left(A1)

HTH,
Jim

"Pete_UK" wrote in message
ups.com:

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