Extract multiple pieces of a text string that meet a criteria - between parentheses
I want to extract both the 1234 and 4567 from this text string:
"First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it"
I am able to pull the 1234 with this formula:
=IFERROR(MID([TEXT_COLUMN]@row, FIND("(", [TEXT_COLUMN]@row) + 1, FIND(")", [TEXT_COLUMN]@row) - FIND("(", [TEXT_COLUMN]@row) - 1), "")
But I cannot figure out how to extract the second set of numbers between parentheses. Is this possible?