Google Sheets - RegEx REGEXREPLACE, Functions Exctract, Replace, Match Tutorial - Part 3

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
www.google.com/sheets/about/
Website:
www.chicagocomputerclasses.com/

[@LeonardoAugustoThomas]

Great video exactly what I was looking for. Thanks.

[@HaninosMaximus]

Excellent Thank you!

[@DavideFavaro]

Thank you! Really usefull video :)

[@emilianoreyes]

Thank you!

[@evajoyrenomeron3424]

Great video! Learned a lot. Do you happen to have a formula of this on Excel?

[@johnn4314]

thank you. you have some of the most decent videos. Im trying to learn how to apply functions to a group of words that would format it into an email by removing spaces inbetween and substituing "." and adding @gmail on the back end. If you have any advice on where to find the answer that would be great

[@ExcelGoogleSheets]

=SUBSTITUTE(A1," ",".")&"@gmail.com"

[@w35l3y]

Is there any way to do something like: `=REGEXREPLACE(C1; "\$(\d)"; "INDIRECT(A$1)")` where `$1` is backreference to the first group in the regex `(\d)` ?
I mean, calling a function in the replacement parameter and using backreference together.

[@cuneiformscript2665]

🙏🏻

[@milangupta6878]

Hey Team,
=QUERY(data,query,[headers])
Data("The range of cells to perform the query on") - Can we Import data here.
like =QUERY("=IMPORTRANGE()",query,[headers]) - Please Help

[@ExcelGoogleSheets]

ua-cam.com/video/BAdl5_cXWdE/v-deo.html