HELP WITH POSTCODE FORMATTING

[UK EXCEL MAN]

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?

 

[Frank Kabel]

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