Academy ↓
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 .
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]+)