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

Originally Posted by jindon

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

try

Function givemetext(ByVal x As String) As String

Dim iStartPos As Integer, iLastPos As Integer
iStartPos = InStr(1, x, "(")
iLastPos = InStr(1, x, ")")

givemetext = Mid(x, iStartPos + 1, iLastPos - iStartPos - 1)


End Function

Thanks guys !