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


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=542617