Hi Stephen, thanks for the quick response.
Yes, some are formatted correctly, but by no means all of them. In addition, I need it to ignore any that are non UK postcodes, hence the conditioaln lookup to Col K
Rgds
mike