Generate REGEX to use REGEXMATCH in Google Sheets

Create a regexmatch regular expression.

Enter your need, an a text example, and it will generate the REGEXMATCH() formula .

Explain as much or as little as you'd like

Enter an example of the text you want to match

Defaults to A1 if left blank

Examples of REGEXMATCH:

Validate Email Addresses

Check if a cell contains a valid email format by matching against a standard email regex pattern.

REGEXMATCH Formula: =regexmatch(A1,"[\w\-]+(\.[\w\-]+)*@[\w\-]+(\.[\w\-]+)*(\.\w{2,3})+")

Phone Number Validation

Verify if a cell contains a valid phone number.

REGEXMATCH Formula: =regexmatch(A1,\d{3}-\d{3}-\d{4})

URL Detection

Identify if a cell contains a valid URL.

REGEXMATCH Formula: =regexmatch(A1,https?:\/\/[^\s/$.?#].[^\s]*)

Hashtag Identification

Identify if a cell contains a hashtag (#).

REGEXMATCH Formula: =regexmatch(A1,#[^\s]+)

Google Sheets Tools

Google Sheets Tools to make your spreadsheet life better. Create Faster. Style Better. Sell More. Automate Your Business.