formula for postcode

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

Hi

Not sure what this code is supposed to do but all i get is a duplicate of the postcode, what i want to do is take either the first letter or first 2 letters of a british postcode.

regards
chris

Please Login or Register  to view this content.

err seems a bit long but it works!

or shorter

Please Login or Register  to view this content.

Many Thanks for the replies

=LEFT(A1,1)&IF(ISERROR((--MID(A1,2,1)>0)),MID(A1,2,1),"")

this is the solution i opted for as it was the most straight forward and worked for my application.

Regards

Chris