I'm looking for a text formula or VBA code for removing any text between brackets. For example, the following text:
OMI (ANNEM) (DRAMA EDIT V.)
should be corrected to:
Another text will have one set of brackets only like the folowing:
LOONEY TUNES (RE-RUN)
This also to be corrected to:
The text is supplied in Excel sheet in one column, so I can either apply a formula in the adjacent column or loop through the range (For each cell in myRange), depending on the suggested solution.
Thanks in advance for your help,