Postcode Prefix formula

[waxb18]

I have a series of post codes and need to extract the first letter(s) and first number(s),

EG:

AL1 3NF = AL1

S1 4NF = S1

GU12 9NF = GU12

Ive tried =left([cell],4), but this then includes the space in the AL1 code and in case of the S1 postal code include the 4,
so basically im asking if someone would help me by providing a formula???

 

[West Man]

The Find function with the array finds the first location of each digit 0-9. The Min then determines the first of these locations.

 

[dazfoz]

Sorry for resurrecting a 7 year old post....

Im working with postcodes, some of which have spaces, some which do not so its a right mess!

Ive used the answer from the thread to create the following, but I cant help feeling that it is a bit long and overcomplicated (I know there are many ways to skin a cat and Im happy that I get the correct results, but was just wondering if I could streamline it a little!)

=IF(RIGHT(LEFT([@Postcode],MIN(FIND({1,2,3,4,5,6,7,8,9,0},[@Postcode]&"0123456789"))+1),1)=" ",LEFT([@Postcode],MIN(FIND({1,2,3,4,5,6,7,8,9,0},[@Postcode]&"0123456789"))),LEFT([@Postcode],MIN(FIND({1,2,3,4,5,6,7,8,9,0},[@Postcode]&"0123456789"))+1))