View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_1093_] Rick Rothstein \(MVP - VB\)[_1093_] is offline
external usenet poster
 
Posts: 1
Default Get rid off double apostrophe

When I call up the Replace dialog box (Edit/Replace on menu bar or key in
Ctrl+H), put a double apostrophe in the "Find what" field and leave the
"Replace with" field blank, and then click the "Replace All" button, it
works fine for me.

Rick


"Marina Tuttle" wrote in message
...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me to
save the new file. The new title will not take and I cannot close the
file.