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