Hi,

I've imported a lot of addresses from another programme but some of the postcodes haven't been entered correctly, ie, there is a zero rather than the letter O. I would like to be able to highlight any of the postcodes that don't follow the normal UK postcode rule which is any of the formats below.

A9 9AA
A99 9AA
A9A 9AA
AA9 9AA
AA99 9AA
AA9A 9AA

where A is any letter and 9 is any number between 1 - 9

Does anyone know if this can be done or have any suggestions!

Thank you in advance