For the advanced Excel user, this function is amajorupgrade.

REGEXEXTRACT not only saves time but also reduces errors created by complicated workarounds.

To use REGEXEXTRACT, provide the text string to extract from and a regex pattern.

Regexextract example - extract numbers

you’re able to see how it works in the worksheet below.

Multiple matches are returned in an array that spills to the right.

If needed, you’re able to use theTEXTJOIN functionto combine multiple values into a single text string.

Regexextract example - extract numbers

By default, REGEXREPLACE will…

Regexextract example - extract numbers

Regexextract example - extract numbers

Regexextract example - extract numbers

Regexextract example - extract phone numbers

Regexextract example - extract email addresses

Regexextract example - extract dates from text strings

REGEXEXTRACT example - extract all hashtags

REGEXEXTRACT example - using capturing groups

Excel formula: Split text string to character array

Excel formula: Extract date from text string

Excel REGEXTEST function

Excel REGEXREPLACE function

Regexextract example - extract numbers

Regexextract example - extract phone numbers

Regexextract example - extract email addresses

Regexextract example - extract dates from text strings

REGEXEXTRACT example - extract all hashtags

REGEXEXTRACT example - using capturing groups