How to Use Regular Expressions in Excel [NEW FEATURE]

Yes! Regular Expressions are coming to Microsoft Excel. As of this week, three new functions are available in the beta build of Excel; REGEXTEST, REGEXEXTRACT and REGEXREPLACE.

I walk through the news, link to tall the info you need, and go through an example of each of these in a workbook.

This is one of my favorite uses of AI, too. Regular Expressions are notoriously hard to wrap your head around, especially if you don't use them often.

We receive commission on purchases made through some links on this page
_______________________________________________

🎓Software Recommendations:

_______________________________________________
🎓Data Course Suggestions: (coursera)

_______________________________________________
🎓AI Course Suggestions: (coursera)

_______________________________________________

🖥️ Office items I can't live without:

📲 Find me
_______________________________________________
⌚Chapter Time Markers:

00:00:00 - Overview
00:01:57 - test in workbook
00:02:06 - REGEXTEST
00:02:54 - REGEXEXTRACT
00:03:27 - REGEXREPLACE
00:04:06 - Beta Program

=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity #gotsheet #howtousespreadsheets #getgoodatspreadsheets