Wildcard characters in formulas
Wildcard characters help you search for terms with iterations of single or multiple characters. Wildcards can be used in formulas such as XLOOKUP to include relevant terms in match.
Below is the list of wildcard characters and their use cases:
Symbol | Use | Examples |
? | To include any single character | gr?y finds both grey and gray |
* | To include any number of characters | *sheet finds spreadsheet and zohosheet |
~ | To include question mark, asterisk, and tilde | A24~* finds A24* and A24~? finds A24? |
Zoho Sheet supports both wildcards and regular expressions for match. Click here to learn more about the regular expression characters and their examples.