Uploaded March 2026 | Updated September 2026, 2 weeks ago

---

🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join

Download the File:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgAZRgHX7tGcQ53RRYTxdeQvAT8nPTb4U4GcjVKIOiyVUEM?e=49680L


The Previous Video
youtu.be/uKRPZGi64dM?si=EjnAVA9ReqUbtZ9C



📊Do you want to learn Power BI?
Check out our amazing course at accessanalytic.thinkific.com

📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/

The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/


00:00 Introduction
00:44 Using REGEXTEST Instead of Complex Formulas
01:01 Creating Multiple Matches with TEXTSPLIT
03:04 Fixing Spaces with TRIM for Accurate Matching
04:18 Simple Partial Matches Using REGEXTEST
05:52 Multiple Partial Matches with REGEXTEST + Lists
07:03 Using REGEX Patterns for “Begins With” Searches