I have an apostrophe in several cells that only shows when each cell is double clicked on (bringing it into editing mode).
I have hundreds of cells with this "stubborn" apostrophe and edit/replace ' with "nothing" doesn't see it. Again, it only shows up when double clicked on and no other time. This data was imported from a Mainframe application. Is there anything that a mainframe would export that looks like an apostrophe but is not one and makes it stay hidden in the cell until it is either double clicked on or viewed from the formula bar?
Thanks in advance
Bookmarks