Help extracting a particular string of text from a cell.

hello, I am trying to extract "Monin Gourmet Flavorings" from the text string below and am having issues. This is the formula I am trying to use, but it is only extracting the first 12 characters. What should I change to correct this?

Original Text:

Please Login or Register  to view this content.

Formula I need help with:

Please Login or Register  to view this content.

Thanks for any help!

Clayton

Try it like this:

=TRIM(MID(C2,SEARCH("-",C2)+1,SEARCH("(",C2)-SEARCH("-",C2)-1))