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???

 

[VoG]

Try

=LEFT(A1,FIND(" ",A1)-1)

 

[sykes]

=left(a1,find(" ",a1,1)-1)

 

[sykes]

Let's face it Peter, I'm just too slow!!

 

[waxb18]

thanks guys this worked brilliantly

 

[projectile]

How can you only extract the letter(s) prefix , for example

AL1 3NF = AL

S1 4NF = S

GU12 9NF = GU

Thanks

 

[waxb18]

= left([cell],2)

 

[projectile]

i am using that formula already, however not all postcode prefixes are 3 characters long,

for example

S1 4NF = should return S , however this forumla is returning S1

I need the formula to return only prefix letters, not numbers.

hope this makes sense.

 

[waxb18]

=IFERROR(IF(MID(B2,2,1)*1>0,LEFT(B2,1),LEFT(B2,2)),LEFT(B2,2))

Where B2 contains the postcode

 

[projectile]

=IFERROR(IF(MID(B2,2,1)*1>0,LEFT(B2,1),LEFT(B2,2)),LEFT(B2,2))

Where B2 contains the postcode

Hi - thanks for the quick replies

It is returning, invalid name error

=IFERROR(IF(MID(J2,2,1)*1>0,LEFT(J2,1),LEFT(J2,2)),LEFT(J2,2))

postcode on my sheet is in cell J2