Excel: extract only the numbers between Parenthesis

I would like to know what the easiest VBA function is to extract only the numbers that are between Parenthesis For example if I had a cell with (NMLS343432) and I wanted to only extract the number and put it into the cell next to the cell with the value. What is the shortest VBA function that could do this?

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

This thread is current as of April 01, 2014.

For more resources for Microsoft Excel