Share this article
Latest news
With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low
Copilot in Outlook will generate personalized themes for you to customize the app
Microsoft will raise the price of its 365 Suite to include AI capabilities
Death Stranding Director’s Cut is now Xbox X|S at a huge discount
Outlook will let users create custom account icons so they can tell their accounts apart easier
Microsoft introduces new Regex modes for the XLOOKUP and XMATCH functions in Excel
They’re now available for Windows and Mac users.
2 min. read
Published onAugust 14, 2024
published onAugust 14, 2024
Share this article
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Microsoft has rolled out new regex modes for XLOOKUP and XMATCH functions in Excel for Windows and Mac users. Regex, or regular expressions, are sequences of characters that help define search patterns. Imagine looking for a needle in a haystack; regex is the magnet that makes the needle light up.
In a blog post, Microsoft says you can use regex within XLOOKUP and XMATCH functions by setting the [match_mode] = 3 and using a regex pattern as the lookup_value. This means you can now match parts of text in a cell or any other text pattern that can be described with regex.
For those who might be new to this, standard tokens include “[0-9]” for any numerical digit, “[a-z]” for a character in the range of a to z, and “.” for any character, among others. And if you’re feeling stuck,Microsoft suggests trying out Copilotfor regex patterns.
Before diving in, it’s important to note that these functions are currently in the Beta channel. Windows users will need Version 2408 (Build 17931.20000) installed, while Mac users should have Version 16.89 (Build 24080715).
As with all things in the beta phase, Microsoft advises against using these functions in critical workbooks until they are generally available. It’s a bit like testing the waters before taking the plunge.
So, what do you think? Are you ready to give these new regex modes a whirl and see how they can transform your Excel experience? Whether you’re a data analyst, a student, or just someone who loves organizing data, this update could be a game-changer.
You can read more about Microsoft Excel’s new Regexmodes here.
More about the topics:Excel,Microsoft 365
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, Claudiu is focused on whatever comes new from Microsoft.
His abrupt interest in computers started when he saw the first Home Computer as a kid. However, his passion for Windows and everything related became obvious when he became a sys admin in a computer science high school.
With 14 years of experience in writing about everything there is to know about science and technology, Claudiu also likes rock music, chilling in the garden, and Star Wars. May the force be with you, always!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, with 14 years of experience in writing on everything there is to know about science, technology, and Microsoft
