Simple searches let you find items (cells, formulas etc.) containing one or more character strings. You can also find items that do not contain specified character strings.
Precede the characters you are searching for with a "+" and the characters you want to exclude with a "-". If neither a "+" nor a "-" is used, "+" is assumed.
To search for several character strings at the same time, separate them with spaces.
Examples
- +hello +world
This finds items containing both hello and world
- +hello -world
This finds items containing hello but not world
To search for a phrase containing one or more spaces, surround the entire phrase with quotes. If the phrase itself contains quotes, replace each quote with two quotes.
Examples
- +"hello world"
This finds items containing the phrase hello world
- +"hello ""world"""
This finds items containing the phrase hello "world"
