Feedback by UserVoice

Perry Wheeler

My feedback

  1. 601 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Perry Wheeler supported this idea  · 
    An error occurred while saving the comment
    Perry 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.

Feedback and Knowledge Base