Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)
VloĆŸit
- Äas pĆidĂĄn 16. 06. 2024
- Join 400,000+ professionals in our courses here đ 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: 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: 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 FINA...
New Excel GROUPBY & PIVOTBY Functions: âą Excel GROUPBY & PIVOTB...
đâ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
đ Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
đ„ RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: 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