Find a number in a string

[Carly]

Is there anyway in which I can find the position of a number in a string?

I have got a postcode (i.e. AB10) and I want to pull out the alpha characters that appear before the number.

 

[mikerickson]

Try
=LEFT(AB10, MIN(FIND({1,2,3,4,5,6,7,8,9,0}, AB10&"0123456789"))-1)

 

[GTO]

Is there anyway in which I can find the position of a number in a string?

I have got a postcode (i.e. AB10) and I want to pull out the alpha characters that appear before the number.

Sorry, are you wanting to return the numbers, or the letters?

 

[Carly]

Thanks for the replies, I will try the formula...

GTO...I am wanting the return the letters

 

[Carly]

Thank you, the formula worked.
Much appreciated.