You can remove the apostrophe after the event with "Find and Replace"

In the "Find" box use "^'" and leave the "Replace with" box empty.

Check the "Search using regular expressions" and "Also search within formulae" boxes.