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

[Jtwa]

Sentence	Extracted Words
I want this word (Michael) and this other word (Jordan) extract	(Michael) (Jordan)
I want this (Lebron) as well as (Kobe) and finally (Curry)	(Lebron) (Kobe) (Curry)
Simple (NBA)	(NBA)

<tbody>
</tbody>

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
1	Sentence	Extracted Words
2	I want this word (Michael) and this other word (Jordan) extract	(Michael)	(Jordan)
3	I want this (Lebron) as well as (Kobe) and finally (Curry)	(Lebron)	(Kobe)	(Curry)
4	Simple (NBA)	(NBA)

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula B2 =IFERROR(TRIM(LEFT(SUBSTITUTE(MID($A2,FIND("|",SUBSTITUTE($A2,"(","|",COLUMNS($B2:B2))),LEN($A2)),")",")"&REPT(" ",LEN($A2))),LEN($A2))),"") <tbody> </tbody>

<tbody>
</tbody>

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