How can I use regular expressions in Excel and take advantage of Excel's powerful grid like setup for data manipulation?
- In-cell function to return matched pattern or replaced value in string.
- Sub to loop through a column of data and extract matches to adjacent cells.
- What setup is necessary?
- What are Excel's special characters for Regular expressions?
I understand Regex is not ideal for many situations (To use or not to use regular expressions?) since excel can use
Instr type commands for similar manipulations.