Excel REGEX SEARCH Function

Hi good people! I need to create a RegEx function that will work the same way Excel SEARCH or FIND function works.
For example, the SEARCH function returns the position of a part of text within a string.
I want a RegEx SEARCH function that will match a pattern and return the location of the pattern within a string.
Anybody can help, please?
186.png

Are you required to use or be compatible with Excel? If not, Google sheets has built in functions for working with regular expressions that should be useful for your project: https://www.benlcollins.com/spreadsh...egex-formulas/

Rexex is not a good subject to start with if you are willing to learn VBA. It's hard to read/understand. But check this out (If it is always just one email, you can remove ".Global = true", now it finds every email in the string)

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.