Skip to content

EszopiCoder/excel-regexp-fx

Repository files navigation

Regular Expression Functions Excel Add-In

Purpose and Features

  • Translate regular expression functions from Google Sheets not currently supported in Microsoft Excel

Compatibility

Microsoft Excel 2010+ (OS must be able to support regular expression object)

Installation

  1. Download 'Regular Expression Add-In 1.1.xlam'
  2. Follow these instructions from Microsoft

Usage

  • The functions are located under the 'Formulas' tab under the 'Function Library' group in the 'Text' category (see images).
  • Please use the following links for tutorials and documentation on regular expressions
Function Name Documentation
REGEXMATCH() Link
REGEXEXTRACT() Link
REGEXREPLACE() Link

Sample Images