HELP WITH POSTCODE FORMATTING

[Guest]

4 possible uk postcode formats (AANN NAA, ANN NAA, AAN NAA, AN NAA)
A="ALPHA", N="NUMBER"

Does anyone know of a custom format/formula so that I can format data to suit?

 

[Guest]

Hi
not possible with a format as you have characters in your data