View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Finding cells that contain an apostrophe

Martin,
Thanks for the suggestion. Unfortunately, your search criteria does not
find cells that contain an apostrophe as the FIRST character in the cell
(which is what I'm trying to find).
Bob


"MartinW" wrote:

Hi Bob,

Use a tilde in your find criteria like this. ~'
Forget the double quotes.

HTH
Martin