There are three new functions coming to Excel for regular expressions (regex). Regex has been available in Excel before through VBA or Python, but this is the first time it's accessible as a native grid function.

So I thought it would be a good time to go over some basics of what a regular expression is and how to use them. This video is mostly just the first part - what kind of patterns are possible. I'll add another one shortly to show how you can use them for extracting, filtering, replacing, and rearranging.

You can get the file I used in the video here:
[ Ссылка ]

And I'll be adding a few more videos to this playlist over the next few days:
[ Ссылка ]

Useful links:
Regex101: [ Ссылка ]
Regex syntax 'cheat sheet': [ Ссылка ]
Function announcement: [ Ссылка ] (note there are links to pages with additional detail on each function)

Sections
00:00 Introduction & resources
03:53 Basic patterns
08:45 Repetition and wildcards
18:52 Capture groups

свернуть