LEFT function

[SimonHughes]

Hi, I have a PostCode column with alpha/numeric data as shown below. I am using the LEFT function to extract the first two characters but want to only extract the alpha detail. Can anyone suggest a formula that will do this?

AB1 5ST
B1 6TT
B3 7UY
BB 1GF
BD 2HT

What I want to end up with is (I know I can use replace function to get rid of numbers but that is not very efficient)
AB
B
B
BB
BD

 

[Rick Rothstein]

Give this formula a try...

=LEFT(A1,2-ISNUMBER(--MID(A1,2,1)))

 

[SimonHughes]

Hi Rick,

Thats just the job, many thanks indeed.