Removing characters with VBA

[paulsolar]

Hi All

I thought this was going to be easy to accomplish but I'm having a lot of trouble with it.

I have a long list of postcodes, in the UK postcodes come in quite a few formats but i just want to achieve a simple thing.

Postcodes can look like the below:

NP12 9AF
NP126AF
CF32 9PP
B1 9AA

I only need the letters before the first number, so my new list would look like the below

NP
NP
CF
B

I'm sure there must be an easy way of doing this but cant seem to come up with a simple solution

Any help is greatly appreciated.

Cheers

Paul

 

[paulsolar]

Hi Rick

i was just finishing up for the night when your reply was posted, but:

I couldn't resist trying it as I didn't think it was possible to do this with such a short bit of code. I thought Fluffs was short, but credit where it's due you have reduced it to the essentials. Spot on it works brilliantly

thanks to everyone for taking the time to look.

Kind regards

Paul