As the subject suggests, I'm trying to extract some text but seem to be spinning my wheels a little bit. I'm getting better at it but I'd definitely put myself in the novice category of Excel users.
The source text is in this format:
xxxx-xxxx (Some text here)
xxxx-xxxx (Some other text here(testing))
I want to extract the text between the outermost brackets and my current formula reads as follows:
=MID(L50,SEARCH("(",L50)+1,SEARCH(")",L50)-SEARCH("(",L50)-1)
This works for scenarios where the text has just the opening and closing bracket but when there's brackets embedded in the text, I get "some other text here(testing"
Is there a clean(er) way of doing this? Thank you in advance!
The source text is in this format:
xxxx-xxxx (Some text here)
xxxx-xxxx (Some other text here(testing))
I want to extract the text between the outermost brackets and my current formula reads as follows:
=MID(L50,SEARCH("(",L50)+1,SEARCH(")",L50)-SEARCH("(",L50)-1)
This works for scenarios where the text has just the opening and closing bracket but when there's brackets embedded in the text, I get "some other text here(testing"
Is there a clean(er) way of doing this? Thank you in advance!