take text between "(" and ")" and put in cell

how can i take a cell with some text that includes bracketted text and take the text within the brackets to put into another cell.

for example, if i had "hello (how) are you" in A1, what formulae would i use to just take the "how" and put it in B2, assuming the position of the bracketted text varies in each cell and the size of the text in the bracketts vary?


Regards, jamie

Try

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-1-FIND("(",A1))