601 votes39 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion! We’re fans of Regex and its ability to parse text too.
If you’d like to see Regex support in Excel, please keep the votes rolling in.
- JoeMcD [MS XL]Perry Wheeler supported this idea ·
An error occurred while saving the commentPerry Wheeler commented
Support this 100%.
Don't over-complicate or attempt to simplify it, just implement a =REGEX(String) formula based in one of the industry-standard models (PCRE maybe?). I have a VBA version that I use all the time, but, as it uses the MS RegEx library 5.0 it is an incomplete implementation (no look-behind).
For me, this is probably the single biggest missing game-changer function in Excel and is the one that I most have to build workarounds for. I know there are those that argue that most functionality can be duplicated using existing functions but, once you get past the basics, these become horrifically complex, difficult to debug, nested messes to emulate something that can be done in a few chars of regex.