using a single quote ' in SEARCH function
I'm trying to see if the text in a cell contains the single quote (or
apostrophe). How can I put that in my SEARCH function. Surrounding the
single quotes with double quotes, like this SEARCH("'", A1) doesn't work. I
know there must be a forcing character to embed special characters in string
literals, but the documentation with 2007 Beta 2 is somewhat lacking, or I
just can't find it.
--
ExTexan
|