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.