search question mark in excel (?)

tried to search for the question mark in Excel but it is treated as a wildcard instead.

Found that the escape char in Excel is ~. Which means “~?” to find a question mark, and “~~” to find a tilde.

http://support.microsoft.com/?kbid=214138

2 Comments »

  1. peter said,

    April 5, 2012 at 4:10 am

    can’t find question marks

  2. peter said,

    April 5, 2012 at 4:14 am

    can’t find question marks using find and replace

RSS feed for comments on this post · TrackBack URL

Leave a Comment