ExcelBanter - HELP WITH POSTCODE FORMATTING

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HELP WITH POSTCODE FORMATTING (https://www.excelbanter.com/excel-worksheet-functions/8320-help-postcode-formatting.html)

UK EXCEL MAN

HELP WITH POSTCODE FORMATTING

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

"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?

All times are GMT +1. The time now is 06:34 AM.