Extracting all words that begin with "(" and ending with ")"

[Jtwa]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sentence[/TD]
[TD]Extracted Words[/TD]
[/TR]
[TR]
[TD]I want this word (Michael) and this other word (Jordan) extract[/TD]
[TD](Michael) (Jordan)[/TD]
[/TR]
[TR]
[TD]I want this (Lebron) as well as (Kobe) and finally (Curry)[/TD]
[TD](Lebron) (Kobe) (Curry)[/TD]
[/TR]
[TR]
[TD]Simple (NBA)[/TD]
[TD](NBA)[/TD]
[/TR]
</tbody>[/TABLE]

I'm not sure how to do something like this. The best i could do was just one 1 word using this
=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("(",A1),LEN(A1))," ",REPT(" ",200)),200))

 

[Eric W]

Try:

	A	B	C	D	E

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FAFAFA"]Sentence[/TD]
[TD="bgcolor: #FAFAFA"]Extracted Words[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #FAFAFA"]I want this word (Michael) and this other word (Jordan) extract[/TD]
[TD="bgcolor: #FAFAFA"](Michael)[/TD]
[TD="bgcolor: #FAFAFA"](Jordan)[/TD]
[TD="bgcolor: #FAFAFA"][/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: #FAFAFA"]I want this (Lebron) as well as (Kobe) and finally (Curry)[/TD]
[TD="bgcolor: #FAFAFA"](Lebron)[/TD]
[TD="bgcolor: #FAFAFA"](Kobe)[/TD]
[TD="bgcolor: #FAFAFA"](Curry)[/TD]
[TD="bgcolor: #FAFAFA"][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #FAFAFA"]Simple (NBA)[/TD]
[TD="bgcolor: #FAFAFA"](NBA)[/TD]
[TD="bgcolor: #FAFAFA"][/TD]
[TD="bgcolor: #FAFAFA"][/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B2[/TH]
[TD="align: left"]=IFERROR(TRIM(LEFT(SUBSTITUTE(MID($A2,FIND("|",SUBSTITUTE($A2,"(","|",COLUMNS($B2:B2))),LEN($A2)),")",")"&REPT(" ",LEN($A2))),LEN($A2))),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Put the formula in B2 and drag down and across as needed.