Unable use of regular expressions (RegEx) in Excel

[Nhattha]

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

I can't call this function via ' =regex ' 

Could you please help on this issue?

Thank you

[#2]

@Nhattha 

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