Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
Regex, or regular expressions, is now available in Excel beta version! This makes it SO much easier to search, match, and manipulate text. (note: currently not all beta users have access. Microsoft is slowly rolling these out.)
⬇️ Download the free RegEx workbook and cheat sheet: https://pages.xelplus.com/regex-excel...
With regex, you can quickly find all email addresses in a list, reformat dates, or correct typos in a large dataset. You can extract phone numbers from text or change the format of thousands of rows with just a few clicks.
In this video we'll cover two new Excel functions:
▶ REGEXEXTRACT: This Excel function extracts specific text from a string using patterns called regular expressions (regex). It can find and pull the first match, all matches, or parts of the first match.
▶ REGEXREPLACE: This Excel function lets you replace parts of a text string using patterns called regular expressions (regex). This is useful for cleaning up data or making consistent changes across a dataset.
00:00 Regular Expression Regex in Excel
02:37 Extract Email Addresses with Excel REGEXEXTRACT
07:37 Extract Text Inside Parentheses with Excel REGEXEXTRACT
09:27 Extract Dates from Text with Excel REGEXEXTRACT
10:56 Extract Multiple Dates from Text in Excel
11:49 Extract Website URL from Text in Excel
14:31 Split Combined Words in Excel
14:59 Replace Leading Zeros with Excel REGEXREPLACE
16:06 Replace Special Characters with Excel REGEXREPLACE
17:30 Insert a Character at Specific Positions
18:34 RegEx Cheat Sheet
18:47 Wrap up
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
/ @leilagharani
🎬 LINKS to related videos:
We FINALLY get the New Excel functions we've been Wanting! • Breaking News! We FINALLY get the New...
New Excel GROUPBY & PIVOTBY Functions: • Excel GROUPBY & PIVOTBY Functions - A...
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #regex #regularexpressions
Watch video Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) online without registration, duration hours minute second in high quality. This video was added by user Leila Gharani 22 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 325,875 once and liked it 9.9 thousand people.