regextil is here for those who need the power of Regular Expressions inside their formulas.
regextil is a native add-in for Excel built on top of Excel-DNA that can empower your spreadsheets and your VBA macros.
Ribbon Tab
The ribbon tab for easy access to each functionality
Function re_extract_generic_string_by_pattern
Example 1: call of re_extract_generic_string_by_pattern
Function re_extract_generic_string_by_pattern
Example 2: call of re_extract_generic_string_by_pattern
Nested functions
Example 3: nested call of re_extract_generic_field_by_sep in re_extract_generic_string_by_pattern
Function re_match
Example 4: re_match returns true or false for quick comparisons
Function re_replace
Example 5: re_replace returns the given string with desired replacements
Function re_implode
Example 6: re_implode returns a string of separated values from a given range and a given separator