Extract text between characters (parentheses) in Excel and Google Sheets
=MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)+0
A2 = data cell
above formula to extract the text inside parentheses ( )
=MID(A3,SEARCH("[",A3)+1,SEARCH("]",A3)-SEARCH("[",A3)-1)+0
above formula to extract the text inside square brackets [ ]
=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 "/"
