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