Extract text between characters (parentheses) in Excel and Google Sheets

  1. =MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)+0

    • A2 = data cell

    • above formula to extract the text inside parentheses ( )

  2. =MID(A3,SEARCH("[",A3)+1,SEARCH("]",A3)-SEARCH("[",A3)-1)+0

    • above formula to extract the text inside square brackets [ ]

  3. =SUBSTITUTE(MID(SUBSTITUTE("/" & A4&REPT(" ",6),"/",REPT(",",255)),2*255,255),",","")

    • above formula to extract part string between two same characters. In this example, inside "/"

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Extract text inside characters (parentheses) in Excel

How to extract text between characters (parentheses) in Excel?
Extract text between characters (parentheses) in Excel

EXTRACT TEXT BETWEEN CHARACTERS — EXCEL FORMULA AND EXAMPLE

  1. =MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)+0

    • A2 = data cell

    • above formula to extract the text inside parentheses ( )

  2. =MID(A3,SEARCH("[",A3)+1,SEARCH("]",A3)-SEARCH("[",A3)-1)+0

    • above formula to extract the text inside square brackets [ ]

  3. =SUBSTITUTE(MID(SUBSTITUTE("/" & A4&REPT(" ",6),"/",REPT(",",255)),2*255,255),",","")

    • above formula to extract part string between two same characters. In this example, inside "/"

Extract text inside characters (parentheses) in Google Sheets

How to extract text between characters (parentheses) in Google Sheets?
Extract text between characters (parentheses) in Google Sheets

EXTRACT TEXT BETWEEN CHARACTERS — GOOGLE SHEETS FORMULA AND EXAMPLE

  1. =MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)+0

    • A2 = data cell

    • above formula to extract the text inside parentheses ( )

  2. =MID(A3,SEARCH("[",A3)+1,SEARCH("]",A3)-SEARCH("[",A3)-1)+0

    • above formula to extract the text inside square brackets [ ]

  3. =SUBSTITUTE(MID(SUBSTITUTE("/" & A4&REPT(" ",6),"/",REPT(",",255)),2*255,255),",","")

    • above formula to extract part string between two same characters. In this example, inside "/"