Use regular expressions in Numbers on iPhone, iPad, iPod touch and Mac, and online on iCloud.com

Combine REGEX and REGEX.EXTRACT with other functions in Numbers to bring the power and flexibility of regular expressions to calculations in your spreadsheets.

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 10.1 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:

  • FIND
  • SEARCH
  • SUBSTITUTE
  • TEXTAFTER
  • TEXTBEFORE
  • TEXTBETWEEN
  • COUNTMATCHES
  • AVERAGEIF
  • AVERAGEIFS
  • COUNTIF
  • COUNTIFS
  • IF
  • IFS
  • MINIFS
  • MAXIFS
  • SUMIF
  • SUMIFS
  • MATCH
  • XMATCH
  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP

 

Published Date: