Using VBA to create your own functions to:
a) Check if your expression is found in the cell value/text string
b) Find AND replace the expression


I use regex101.com to test out my expressions.
I had some situations where I used regexr.com instead, but the expression didn't work as expected in Power Automate Dekstop.


00:00 - Intro to Regex / regex101.com
02:27 - RegexFound function
06:13 - RegexReplace function

свернуть