retrieve the entire text from the "[(" ")]" from string

[alexgoaga]

Hello, it's there a function , excep regex that can give me the text / sentence between "[(" ")]" from string ?

function than can retrieve the entire text from the "[(" ")]"

Examples :

THE TEXT RESULTS
[(cat)] cat
[(orange)] orange
long sentence with [(cats)] cats
another possible thing with [(test123)] lets continue test123
[(this is text)] this is text
text here [(this is text)] and here this is text

Thanks

[jindon]

Formula in D4

=IFERROR(MID(B4,FIND("[(",B4)+2,SUM(FIND({")]","[("},B4)*{1,-1})-2),"")

then copy down

[alexgoaga]

Formula in D4

=IFERROR(MID(B4,FIND("[(",B4)+2,SUM(FIND({")]","[("},B4)*{1,-1})-2),"")

then copy down

Nice one ! but it as vba function i need for the project from a selected range like =givemetext("B4")
thank you

[jindon]

=GetText(B4)

Please Login or Register  to view this content.

[mohan.r1980]

try

Please Login or Register  to view this content.

[alexgoaga]

Thanks guys !