Let’s see how to extract text between two Commas/brackets/parentheses in excel.
The data below represents an address and we want to extract the “Providence” which is present between two columns.
Enter the formula
=LEFT(RIGHT(A1,FIND(“,”,A1)),FIND(“,”,RIGHT(A1,FIND(“,”,A1)))-1)
in cell B2 to extract the data between tow commas in excel.
As you could see, we have extracted the data.
Replace comma in the given formula with brackets or parentheses to extract Extract Text Between brackets or parentheses respectively in Excel.
Hope this helped.
