Remove exact match only

Thank you for the reply which sort of confirms my worst fears. Unfortunately, the data is exceptionally poor quality - it's been entered in numerous different ways by any number of different users and there is no way of really separating each aspect of the address - commas would have been nice, but they are a rare commodity and highly prized in this office...you'd almost think that the company had bought keyboards without them! In practice, this means that I will need to sift through the cells manually anyway, it would just have been nice to automate a little bit of the process.

I still think looking for a number 2 chars before the start of the matching section of the field would filter out street names that match area names.