How to take the informations in brackets separate from a huge worksheet?

Being bank transfer received ( mrdf38/b-5)
Rent deposited ( hac514 & 515 )
Being rectification entry passed due inappropriate rent allocation for the year 2011 & 2012 as per (jv 7913).
Being rent from jv1/71 deposited
Being rent deposited ( mrb-701 )

If those text strings are in A1, A2, A3, etc.. Put this formula in B1 and copy down:

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

You will get errors on the rows with no bracketed info.

To avoid the errors you can use:

=IF(ISNUMBER(SEARCH("(",A1)), TRIM(MID(A1, FIND("(", A1)+1, FIND(")", A1)-FIND("(",A1)-1)), "")