Extract Number/Text Between Two Commas/brackets/parentheses in Excel

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.

Capture

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.

Capture




Capture

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.

Share The Knowledge

Random Posts

Leave a Reply