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

"UK EXCEL MAN" wrote:

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?