Does REGEXEXTRACT work in Excel?

Native REGEXEXTRACT is available in Google Sheets. Microsoft recently introduced REGEXEXTRACT for Excel 365 Insiders, but for legacy Excel, you must use nested IF(ISNUMBER(SEARCH())) or Power Query.

RegexExtract Formula Generator

Stop writing endless nested FIND() or IF() statements. Use this generator to extract multiple target words from a cell using Google Sheets' REGEXEXTRACT function. Perfect for categorizing chaotic data.

Multi-Word Regex Generator

Extract multiple specific words from a cell instantly (Google Sheets).

Target Cell

Words to Extract (Comma separated)

Case Sensitive

Generated Formula

=IFERROR(REGEXEXTRACT(A2, "(?i)(Apple|Banana|Orange)"), "Not Found")

Why use REGEXEXTRACT instead of wildcards?

Standard Excel functions like SEARCH or VLOOKUP with wildcards (*) are often clumsy when you need to match against a list of 10 different words.Google Sheets offers a native regex engine that allows evaluating conditional patterns like (Apple|Banana|Orange) in one go.

If you're using Excel, consider using the new REGEXEXTRACT function (available in Excel for Microsoft 365) or bridging the gap with Power Query.