Excel: Extract Text Between ()

Hi all, I don't know if anyone can quickly help with this, but is there a way of extracting just the text between two brackets ()? I have a messy spreadsheet that is largely free text and I only need the ID's that are always between two brackets. There are several sheets to search through, so the soloution will have to search the whole workbook. Many thanks for any help.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 20, 2014.

For more resources for Microsoft Excel