Validation of UK Postcodes all formats

[Engineerlee]

Hi
I am looking to validate UK postcodes in a similar fashion to another thread on here but it is quite old so thought I would generate a new one. Hopefully this isnt against the rules

UK Postal Code Validation

Hi, I am looking to validate UK Postal Code using MS Excel formula, can anyone help!!! The postal code is should be in the following format: AN NAA ANN NAA AAN NAA ANA NAA AANA NAA AANN NAA When A is alphabet and N is number. If the condition is incorrect then highlight that particular cell...

www.mrexcel.com

Can some one help
I am looking to do the same sort of validation including the CIKMOV check and illegal characters but with more postcode formats


My postcode field that is always 9 characters in length
There are no spaces between the segments of the postcode

Where a Postcode isnt the full 9 characters it is padded with spaces - these need to be also validated

AN[Space][Space][Space][Space][Space][Space][Space]
ANN[Space][Space][Space][Space][Space][Space]
AANA[Space][Space][Space][Space][Space]
ANNAA[Space][Space][Space][Space]
ANNNAA[Space][Space][Space]
AANNAA[Space][Space][Space]
ANANAA[Space][Space][Space]
AANANAA[Space][Space]
AANNNAA[Space][Space]
ANNAANA[Space][Space]
ANNNAANA[Space]
AANNAANA[Space]
ANANAANA[Space]
AANANAANA
AANNNAANA

Where A is alphabet character and N is number. [Space] is a physical space and not a word
If the condition is incorrect then highlight that particular cell that contains the incorrect postcode.
Many thanks in advance.
In reality they would look something like this

S1
S11
EC1A
S12BB
S112BB
LS12BB
W1A1BB
EC1A2BB
LS112BB
S12BB9Z
S112BB9Z
LS12BB9Z
W1A1BB9Z
EC1A2BB9Z
LS112BB9Z


Many thanks in advance

 

[Peter_SSs]

Hopefully this isnt against the rules

No it's not - but creating duplicates of your own is.

Validation of UK Postcodes all formats

Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.