Use regular expressions in Numbers on iPhone, iPad, iPod touch, Mac, and online at iCloud.com
- June 7, 2024
- Apple
Table of Contents
Use regular expressions in Numbers on iPhone, iPad, iPod touch, Mac, and
online at iCloud.com
Combine REGEX and REGEX.EXTRACT with other functions in Numbers to bring the power and flexibility of regular expressions to your spreadsheet calculations.
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
Learn more
Published Date: March 23, 2021
Read User Manual Online (PDF format)
Loading......