Try copying the text in the cell, then write the formula and paste in the text from the clipboard rather than writing it out yourself.
You can also probably export the data as CSV and do a find and replace on that kind of an apostrophe (using the clipboard again to copy the apostrophe before engaging the find/replace) either in a spreadsheet program or even a simple text editor. Then reimport the csv into CODAP.