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.