Hi Pete,

This worked a treat!!!

Thank you very much.

Mary.

Pete_UK wrote:
Roger missed something from the LEFT functions - try this:

=IF(LEFT(A1,1)="B",1,IF(LEFT(A1,1)="A",2,IF(LEFT( A1,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

Hi Roger,

[quoted text clipped - 17 lines]

Mary.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1