Hi i currently have this formula to take the first 2 letters of a postcode,

=LEFT(B13,2)

what i need to do is have a formula that takes the first 2 characters but if the second is a number to ignore it and just put in 1 letter, as some uk postcodes have only i letter then a number, any ideas on this anyone.

regards
chris