Forum Discussion
Unable use of regular expressions (RegEx) in Excel
I love function regex in R programming and want to use in excel, then I enable MS VB script as method in this clip. https://youtu.be/aLIVaUxSWgA But it not working 😔
I can't call this function via ' =regex '
Could you please help on this issue?
Thank you
1 Reply
You cannot use Regex directly in a cell formula.
Instead, you can use it in macros.
You can also use it in custom functions written in VBA. You can then use such a function in a cell formula.
See General Purpose UDFs for using Regular Expressions in Excel for some examples
