Hi Chayes


You are not explaining the criteria to check for.
Can you explain with an example what you are looking to achieve.
Tony

Hi Tony

Ok thanks for getting back.

I have pages of addresses which need to have the postcode identified in each and moved down a line.

The postcodes are in the format outlined in my original post. I've used 'L' to signify a letter and 'N' for a number.

So for example

LN NLL could be M6 7TY , or E3 4GH

A search and replace or some VBA to find the various combinations or Numbers and Letters would be the solution. I assume wildcards would be used.

Hope you can help.