🔥 400,000+ professionals trust our courses—start your journey here 👉 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: 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: ➡️ Join this channel to get access to perks: 🎬 LINKS to related videos: We FINALLY get the New Excel functions we've been Wanting! New Excel GROUPBY & PIVOTBY Functions: 👕☕ Get the Official XelPlus MERCH: 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🎥 RESOURCES I recommend: More resources on my Amazon page: 🚩Let’s connect on social: Instagram: LinkedIn: 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