Regex day 3 - replacement and lookarounds
This is day 3 of exploring the new Regex functions in Excel, and today I finally get to REGEXREPLACE, which might be my favorite of them all! I also talk a bit about look-aheads and look-backs and when you need them (and many situations where you don't).
The playlist with all my regex videos is here (possibly still more to come, I'm not sure...):
• Regex in Excel
You can get the file I used in the video here:
https://1drv.ms/x/s!Aryypvyx4xIO9WkCz...
Useful links:
Regex101: https://regex101.com/
Regex syntax 'cheat sheet': https://developer.mozilla.org/en-US/d...
Function announcement: https://insider.microsoft365.com/en-u... (note there are links to pages with additional detail on each function)
Rex Egg (advanced): https://www.rexegg.com/
Sections
00:00 Introduction
04:32 Using the match in the replacement
08:53 Look-ahead and look-back
16:47 Advanced sanitizing and rearranging with lookarounds