How do I get regex support in excel via a function, or custom function?

Posted by blunders on Stack Overflow See other posts from Stack Overflow or by blunders
Published on 2010-12-29T18:51:06Z Indexed on 2010/12/29 18:54 UTC
Read the original article Hit count: 144

Filed under:
|
|

It appears that regex (as in regular expressions) is not supported in excel, except via VBA. Is this so, and is it is, are there any "open source" custom VBA functions that support regex. In this case I'm looking to extract complex pattern within a string, but any implementation of a custom VBA function that expose support of regex within the function itself would be of use. If you know of semi-related function such as the IS function, feel feel to comment, though I'm really looking for a full regular expression implementation that is exposed via functions. Might even be open to a pay to use add-in if the implementation is good.

If you have questions, please comment.

© Stack Overflow or respective owner

Related posts about regex

Related posts about excel