I am attempting to create a formula to join all rows of data in a column into a single cell in another column if between a specific text string. I have the piece to join the data points if criteria is met using the TEXTJOIN function.
What I am lacking is how to search a column between 2 text strings. I hope my explanation was clear. Below is an example to return everything between the word bingo.
Current Column Data Desired Data in Single Cell
Bingo 1,2,3,4
1
2
3
4
Bingo
Bookmarks