J
Jazzman10
Is there a way of adding a space between letters and numbers in a cell to
seperate them but keep them in the same cell?
I am based in the UK and have an excel list of UK Postcodes that need
cleaning, as instead of having a space correctly inbetween them eg NG12 9NA
some (not all) are listed incorrectly with no space eg NG129NA.
For reference UK Postcodes can have either 3 or 4 digits (NG1 or NG12) in
the first part but only ever 3 digits (9NA) in the second part. I am using
Excel 2003 on Windows XP Professional.
Any help would be greatly appreciated.
seperate them but keep them in the same cell?
I am based in the UK and have an excel list of UK Postcodes that need
cleaning, as instead of having a space correctly inbetween them eg NG12 9NA
some (not all) are listed incorrectly with no space eg NG129NA.
For reference UK Postcodes can have either 3 or 4 digits (NG1 or NG12) in
the first part but only ever 3 digits (9NA) in the second part. I am using
Excel 2003 on Windows XP Professional.
Any help would be greatly appreciated.