Extract data from field

[Lyncroft]

I've a field and in each row the data is AB1234, ABC1234, AB235, etc. I want to extract just the letters at the beginning. Usually there are either 2 or 3 letters before you hit the numbers. Is it possible to do this. I was thinking along the lines of trying to find the first number and extracting everthing to the left. Of course if there was a space in between this would be easy. Any hints?

 

[mresann]

I have hints. Check out the string manipulation functions Left, Mid, and Instr.

If you need more help check out this post about parsing strings:

Split Name and Phone strings

Although not an exact match, you can get the idea of what you need to do.