Regular expressions are sets of characters used to define search patterns. You can combine simple groupings of these characters to create sophisticated rules to find values within strings of text. Numbers includes two regular expression functions, REGEX and REGEX.EXTRACT, which you can combine with these functions to search, match, and replace data in your tables:
- AVERAGEIF
- AVERAGEIFS
- COUNTIF
- COUNTIFS
- COUNTMATCHES
- FIND
- HLOOKUP
- IF
- IFS
- LOOKUP
- MATCH
- MAXIFS
- MINIFS
- SEARCH
- SUBSTITUTE
- SUMIF
- SUMIFS
- TEXTAFTER
- TEXTBEFORE
- TEXTBETWEEN
- VLOOKUP
- XLOOKUP
- XMATCH