Extracting multiple values from a sentence in single cell with same preceding value. eg. Player 1, Player 2
As the OP is using Google Sheets, there are Google Sheets' functions that will help extract the output.
- Insert another column. It will be used to display the results.
- In this example the inputs are in column A, the outputs are in column B. In cell B2, enter the formula:
=JOIN(CHAR(10), REGEXEXTRACT(A1,REGEXREPLACE(A1,"(Player \d+)","($1)")))
Drag the formula to fill the other cells.
