Uk Post Code Ignoring certain parts formula

Evening Folks,

Working on a database, and trying to get a formula to work on looking at a full post code and listing in another cell the shortened version.

i.e : EH54 5DZ, and showing in other cell just EH

I can do this with formula =LEFT,SEARCH("".L2,2))

But my problem is when I get a post code such as "G21 1DA" or "G1 1DA", where I only want it to show the G on its own, it's the only post code that has one letter in it, and want to ignore the rest.

Can I do this with a generic formula that would cover both my examples above i.e EH54 5DZ = EH & G1 1DA = G?

Cheers,

D.

Just tried, seemed to work with some, but some of the other posts codes are only showig as one letter rather than 2. But perfect with the only postcode with one letter (G)

Where before a postcode IV6 7UA is now only showing as I. As I'll be looking at all postcodes in Scotland.

But thanks for your quick reply, any other idea's

VBA, sorry, never noticed the second formula you entered, that works a treat. Too busy trying the first to notice.

Thanks for your help.