My apologies ... I must have missed the last bracket when I copied and pasted the formula. In this instance, Excel made a good stab at correcting it for me ;-)

Are you saying that you want to "review" each post code in column A and update it, if necessary?

Has anyone else offered such a solution? I'm always kind of wary of overwriting the source data ... at least, initially ... just in case it screws up along the way.

That said' I'll have a look at it and get back to you.

Regards