View Single Post
  #1   Report Post  
UK EXCEL MAN
 
Posts: n/a
Default 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?