Extract each substring from current cell

Hi friends,

A1 cell data is : Microsoft (MS) Google (G) Yahoo (Yho)

I want to extract each words who start with ( and end with ).

B1 will be (MS)
C1 will be (G)
D1 will be (Yho)

How can I do that?

Thank you

Try this one:

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

Here are two solutions. The first requires "helper" cells. It's more efficient but if you don't care for that you can construct "megaformulas" as shown in the second solution.

Dear 6StringJazzer,

Complex one is good for me But when I look your example it couldn't found 3rd (Yho)

Thanks for all friends for their suggestions

For last word I used
=RIGHT(A2,LEN(A2)-FIND("^^",SUBSTITUTE(A2,"(","^^",LEN(A2)-LEN(SUBSTITUTE(A2,"(",""))))+1)

But still don't like this solution because if I have more than 4 parantheses it will crash