Google Sheets - RegEx REGEXMATCH Function & Email Data Validation Tutorial - Part 4

Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH. Unfortunately these functions are not available in Microsoft Excel.

Google Sheets

Website:

[BruinChang]

This series is very instructive. Thanks you.

[takaakiyamada]

The process of making email data validation is very educational. It could be applied to other things as well. Thank you! ;-)

[VictordeMelo]

Ty for this, i have always avoided learning this but you mad it very simple!!

[douglasteixeiragoncalves]

Hello, great content and explanantion.
How can I use regexmatch to validate this number "20.69717" making sure all the following numbers will inuput like this one?

[AsaduzzamanRobin]

How I extract number from text ? like "total 70kg" how i extract 70 from here in google studio or sheets using regex function ?

[tamanitech]

Do you know Google Sheet function that allows you to appear automatically price based on a product ?

[kamruzzamankamran]

how to find and replace any email format from a sheet ??

[estonhumphrey]

I'm trying to remove a quotation mark, how do I do that?

[lazalazarevic]

Can you use or (|) in the regular expression like in regexextract?