Google Sheets - RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial - Part 1

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:

[paulseldn]

I have been trying to figure out how to do this for ages. My thanks for this great video. It will save me so much time. Very well and clearly explained. Also, you don't rush through it like most people on here. very helpful. :)

[jaydencollier]

Thank you so much this is extreamly helpful!

[mikemccartneyable]

Excellent tutorial, thanks for sharing

[miftahulhadi]

THankyou very much for your video, very very 😭

[azenxgaming]

Best tutorial, happy to following you...it's help me a lot, thanks

[ddcowan]

Great beginner video to RE2 syntax. One thing, can you add a link to a sample copy of your sheet used in the explanation?

[StefanoVerugi]

thank you, very easy to follow your tutorials
btw I think you posted REGEXEXTRACT videos in reverse order ?

[NardoParra]

Hi any tips for the #ERROR! result? I'm trying the exact same formulas and I'm always getting that.

[Joe-blyo]

How do I use regex to extract 2 pieces of info, for eg. if I have to tracking numbers how to I extract both of them if they both start with same “Tracking #”.

[ehsanellahi]

Is there any formula that can split/divide data of one row in to multiple rows, keeping the text data same and divide the values depending on some percentages?

[gustavorotondaro]

Thank you for the video! Question...how can you extract multiple words from a cell. For instance, If I had a cell containing "Company X Information Technology and Data Services" and I'd like to extract only the following words: "X", "Technology", "Data Services" - how can I do this? Thanks in advance!

[xJericD_]

How do you enable that example guide above your function when adding regular expressions.

[sonnymiles]

How can we extract the last 2 words from a string? thanks in advance - great tutorial!!

[expert]

Your tutorials are great but it will be helpful if you also provide the file that you are using so that we can practice with you. Thanks for the tutorial.

[NewToneProducer]

how do you pull the characters between brackets [ ] ? For example, when I get Google Form data, the survey questions have the names of different options I gave in brackets like [Option 1] and [Option 2]

[kevinyang]

Hi! These videos have been a huge help but I recently ran into a small problem. For example if I had a column containing things like "product-1-description x1, product-2-description x2, so on so forth, " and my goal is to convert them to "product 1 x1, product 2 x2, etc., " how would I do that. Im new to regex but I can successfully find/replace "product-1-description x1" into "product 1 x1." But everything after that gets deleted. Is there a way to insert a regular expression for that comma so that the following terms get replaced as well?

[MyBilal]

How can I use these functions in Script editor? I am having trouble in completing a task. Any help will be appreciated.

[prempatel]

How to extract word that is before UnderScore
Ex:-" sample1_lab1_part1"

i want to extract "sample1 "

Please help me with this... I tried and got output as "sample_", but i want Just sample

[jeremy_ching]

Hello. I have some lines but put into one cell. I would like to add a "-" at the beginning of every line. What should I do? I try \w but it only works at the first line.

[naomipena]

Is there a way to extract text from the end of a string? I'm looking to extract the handle of a URL.