Hi
I have list of variable length postcodes eg BA1 1AA and BS11 2AA -I am looking for a formula that will remove the middle space in the longer postcode but not the shorter one, ie it will standardise both types to 7 characters long, so BS11 2AA becomes BS112AA, whilst BA1 1AA remains unchanged.
I seem to recall seeing a formula which uses IF SUBSTITUTE which has worked before.
Thanks
Bookmarks