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:
   / @accessanalytic  

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-exc...

The File with Solutions:
https://aasolutions.sharepoint.com/:f...


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/