The value after the equals is the default value.

It took me a little while to clock what the functions all did, so here is some documentation to help you all out.įor those of you not familiar with this particular format of documentation, any inputs with an equals sign after them e.g.

Replace value in string (case sensitive) - =RegExpReplace(cell_reference,regex_goes_here,replace_value,TRUE).

=RegExpReplace(cell_reference,regex_goes_here,replace_value,FALSE).

Replace value in string (case insensitive)

=RegExpFind(cell_reference, regex_goes_here,x,TRUE,0,FALSE).

It does not unfortunately support capturing groups, so you're matching the xth match of the whole regex.

This will return exactly what is matched.

=RegExpFind(cell_reference, regex_goes_here,x,FALSE,0,FALSE).

=ISNUMBER(RegExpFind(cell_reference, regex_goes_here, ,TRUE,1,FALSE))Įxtract value from string (case insensitive) (xth match).

=ISNUMBER(RegExpFind(cell_reference, regex_goes_here, ,FALSE,1,FALSE))ĭoes a cell match regex?* (case sensitive).

Useful examples of Excel regex formulasĭoes a cell match regex?* (case insensitive) If you'd like to dig into the ins and outs I've written out proper documentation in the section after. If you just wish to copy paste, then the next section has examples. I'm only going to focus on two, which most people which will cover the majority of basic use cases: This will then give you access to the following formulas. (Full credit to Patrick Matthews for actually writing these functions, you can find his article on VBA & regex here.) What functions do you get?

You're ready to go! You now have regex in all your workbooks.

If you haven't changed the name it's Regular-Expressions-Examples.

Finally enable the add-in with the same name of this sheet.

File > Options (a new window will open) > Add-ins > Manage Excel Add-ins Go

Then you need to open the add-ins menu 1.

At this point it will automatically select the correct destination. File > Save As > Select Excel Add-in (*.xlam) 2.

Enable editing for the protected sheet.

How could you possibly improve on perfection? You couldn't suggest anything to even slightly change my mind, I am completely.ĭang, that would be pretty sweet. It has everything you could possibly ever want.

How to get to excel add ins on mac