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
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