Brings up the Regular Expression tester than can be used to verify the correctness of regular expressions that will be used with the =RegEx() UDF.
The top third is used to config the regular expression and the subject string with the options to ignore case and perform a global search. Global search force the RegEx engine to return all matches, not just the first:
The second portion of the popup returns all results of the regular expression configured above. This allows examination of the ddata to determine which matches and/or groups are desired:
The bottom sections configures the output processing of the regular expression that would give the final result in the selected cell in Excel. The match and group number are used to select from the data in the results window (above).
Created with the Personal Edition of HelpNDoc: Easily create Help documents