Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)

Leila Gharani May 22, 2024
Video Thumbnail

About

No channel description available.

Video Description

🔥 400,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-courses 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-file 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: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🎬 LINKS to related videos: We FINALLY get the New Excel functions we've been Wanting! https://youtu.be/VWcLM6_Q_00 New Excel GROUPBY & PIVOTBY Functions: https://youtu.be/mCJzhCxEQlM 👕☕ 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: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/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

You May Also Like

Essential Excel Tools

AI-recommended products based on this video

Loading...
Microsoft Office Home & Student 2019 | One-time purchase, 1 person | PC/Mac Keycard

Microsoft Office Home & Student 2019 | One-time purchase, 1 person | PC/Mac Keycard

(277)
$97.89
FREE delivery Jun 19 - 25
50+ bought in past month
Loading...
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

(137)
$19.97
FREE delivery Sat, Jun 14 on your first order
Loading...
RAOYI 5Pack 64GB USB Flash Drive USB Stick USB 2.0 Memory Stick Slide Retractable Thumb Drive 64G USB Drive USB Key for Data Storage (Black Red Blue Green Purple)

RAOYI 5Pack 64GB USB Flash Drive USB Stick USB 2.0 Memory Stick Slide Retractable Thumb Drive 64G USB Drive USB Key for Data Storage (Black Red Blue Green Purple)

(4,402)
$26.09
Prime
1K+ bought in past month
Loading...
Netac 64GB USB Stick USB 3.0 Flash Drive, Up to 90MB/s, Thumb Drive for Data Storage, Pen Drive with Swivel Design, Memory Stick for External Storage Data/Computer/PC/Laptop/Sound

Netac 64GB USB Stick USB 3.0 Flash Drive, Up to 90MB/s, Thumb Drive for Data Storage, Pen Drive with Swivel Design, Memory Stick for External Storage Data/Computer/PC/Laptop/Sound

(6,566)
$12.73
FREE delivery Sun, Aug 10 on your first order
100+ bought in past month
Loading...
KEXIN 64GB USB Flash Drive 3 Pack - Swivel Thumb Drives with LED Indicator, High-Speed USB 2.0 (Pink/Yellow/Cyan) for Data Storage, Bulk Pen Drives Multi-Color Pack

KEXIN 64GB USB Flash Drive 3 Pack - Swivel Thumb Drives with LED Indicator, High-Speed USB 2.0 (Pink/Yellow/Cyan) for Data Storage, Bulk Pen Drives Multi-Color Pack

(1,558)
$17.75
Prime
100+ bought in past month
Loading...
Flash Drive 16GB 5 Pack USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pendrive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (16G, 5Pcs Mixed Color)

Flash Drive 16GB 5 Pack USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pendrive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (16G, 5Pcs Mixed Color)

(983)
$18.04
FREE delivery Sun, Aug 10 on your first order
100+ bought in past month
Loading...
Laplink PCmover Ultimate 11 - Migration of your Applications, Files and Settings from an Old PC to a New PC - Data Transfer Software - With Optional High Speed Ethernet Cable - 1 License

Laplink PCmover Ultimate 11 - Migration of your Applications, Files and Settings from an Old PC to a New PC - Data Transfer Software - With Optional High Speed Ethernet Cable - 1 License

(4,609)
$54.95
PrimeFREE delivery Sat, Jun 14
Loading...
2026 New Embroidery Stitch Book Kit, Stitch Book Embroidery, All-in-One Embroidey StitchBook & Sewing Kit, Comes with a Complete Toolkit and Instructional Tutorial (1set)

2026 New Embroidery Stitch Book Kit, Stitch Book Embroidery, All-in-One Embroidey StitchBook & Sewing Kit, Comes with a Complete Toolkit and Instructional Tutorial (1set)

(1)
$14.90
FREE delivery Jan 23 - Feb 12
500+ bought in past month
Loading...
New Slim 65W USB C Laptop Charger for Lenovo ThinkPad Yoga 7i 7 9i 9 2-in-1 Yoga Book 9i Gen 10 ThinkBook 16 15 14 Gen 8/7 13s 13x 14s IdeaPad Slim/Pro 5X 5i 5 3X 3i 3 2-in-1 Type C Power Cord

New Slim 65W USB C Laptop Charger for Lenovo ThinkPad Yoga 7i 7 9i 9 2-in-1 Yoga Book 9i Gen 10 ThinkBook 16 15 14 Gen 8/7 13s 13x 14s IdeaPad Slim/Pro 5X 5i 5 3X 3i 3 2-in-1 Type C Power Cord

(13)
$24.99
FREE delivery Sat, Jun 21 on your first order