Start a new topic

How to remove punctuation from fuzzy matches?

Sometimes you get a fuzzy match that's almost perfect, except for a difference in punctuation:


With the attached macro you can remove the punctuation via CTRL+ALT+.

Then you'll get:


(I'm currently looking for a way to get the ‘ removed too. And of course, the double space could be removed too. Just another command in the macro.)

Okay, I've solved it. Also added a line to adjust end punctuation and replace 2 or more consecutive spaces with one space. Please use the attached updated version of the macro.


I've updated it, e.g. to remove numbers and round brackets too. Used it today many times, and I'm having fun with it.

Login to post a comment