We help IT Professionals succeed at work.

Data Cleansing & Text Formulas with Excel 2010

Mehawitchi
Mehawitchi asked
on
Medium Priority
394 Views
Last Modified: 2012-03-12
Hello Experts,

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:
OMI

Another text will have one set of brackets only like the folowing:
LOONEY TUNES (RE-RUN)

This also to be corrected to:
LOONEY TUNES

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,
Hani
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Sub supprparen()
For Each cel In Range("A:A")
Do While InStr(cel, "(") > 0
cel.Value = Replace(cel, Mid(cel, InStr(cel, "("), InStr(cel, ")") - InStr(cel, "(") + 1), "")
Loop
Next cel
End Sub

Author

Commented:
Thank you ssaqibh

This is exactly what I needed

Explore More ContentExplore courses, solutions, and other research materials related to this topic.