How to use CHATGPT to do Excel REGEX and is TRIMRANGE useful?

👀 CLICK MORE... for links and overview Yep there's more ➡️ Join the channel to get access to perks: https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join Microsoft Excel 365 has introduced two new functions, REGEX and TRIMRANGE. In this video, we dive into how REGEX helps extract, replace, and test text using regular expressions, making tasks like date extraction and email identification easier. The syntax is unintuitive so I also showcase my Excel Regex Assistant on ChatGPT, which can generate the correct formula for you instantly. We then explore TRIMRANGE a function that dynamically adjusts ranges to optimize performance. While it can be useful, tables are often a better alternative. I break down real-world examples, such as removing non-breaking spaces, improving XLOOKUP with regex, and using trimmed ranges efficiently. But do these functions solve problems or create new ones? Let’s discuss! Share your thoughts in the comments and check out the membership perks for early access and exclusive content. Link to my GPT https://chatgpt.com/g/g-QvM2POM1R-excel-regex-assistance-access-analytic The File with Solutions: https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiUT3CpizhBIlYfxnyy_fzgBagH8BtKZYZXspMzG8hxfxg?e=2JX1aX 00:00 Introduction 00:05 New Excel 365 Functions: REGEX & Trim Range 00:32 Which Excel Version Supports These Functions? 00:45 How REGEX Works in Excel (Extract, Replace, and Test) 01:28 Using ChatGPT’s Excel REGEX Assistant 02:40 Extracting Dates with REGEX in Excel 03:49 Email Extraction & Other Practical Uses 04:45 Solving Non-Breaking Space Issues with REGEX 06:10 Using REGEX Inside XLOOKUP & XMATCH 07:50 Should You Use REGEX? 08:37 What is TRIMRANGE & How Does It Work? 11:41 Final Thoughts – Are These Functions Worth It? The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/ Did you know I've written a book "Power BI for the Excel Analyst"? https://pbi.guide/book/ Connect with me https://wyn.bio.link/