I need a formula to retrieve all values enclosed in parentheses, with each value separated by a comma. For instance, if cell A1 has the content example1.png (/directory/to/example1.png), example2.png (/directory/to/example2.png), I want cell B1 to display /directory/to/example1.png, /directory/to/example2.png. While I can extract a single entry using this formula: MID(A1,FIND(“(”,A1)+1,FIND(“)”,A1)-FIND(“(”,A1)-1), I’m looking for a solution that can handle multiple entries, as the number of parentheses may change in different rows.
try breaking it into steps with helper columns in Excel. Use a combination of SEARCH and LEFT/RIGHT to locate & extract bracketed content piece by piece. might be a bit manual but it’ll get the job done pending a more compact formula solution.