Hello,
I have to iterate multiple times within a cell in Excel and capture them all.
For example., I have this in each cell:
"234343-33433-333333-5500",this is a test, "999999-33433-333333-4444"
I want to use the RegexpFind function ( or any other function ) to capture both (234343-33433-333333-5500, 999999-33433-333333-4444).
The RegexpFind below function
=RegexpFind(F2,"(\d{6})-?(\d{5})-?(\d{6})-?(\d{4})") returns only one instance of the pattern.
234343-33433-333333-5500
How to iterate and capture multiple instances of the patterns in a single cell in Excel.