A simple one hopefully, I am trying to FIND a text string which always
occurs between brackets and copy it into another column.

Example, I want to copy the word "Apples" from cell A1 to cell B1
where A1 has the following Text :

Peaches Cream (Apples) Bannana Cherries.

Many thanks for any help