<div>
Thank you ssaqibh<br />
<br />
This is exactly what I needed
</div>


Thank you ssaqibh

This is exactly what I needed

<div>
Hi ssaqibh - You may be interested in this post<br />
<br />
<a href="https://www.experts-exchange.com/questions/27627620/Data-Cleansing-Text-Formulas-with-Excel-2010.html" rel="ugc">https://www.experts-exchange.com/questions/27627620/Data-Cleansing-Text-Formulas-with-Excel-2010.html</a>
</div>


Hi ssaqibh - You may be interested in this post

https://www.experts-exchange.com/questions/27627620/Data-Cleansing-Text-Formulas-with-Excel-2010.html [https://www.experts-exchange.com/questions/27627620/Data-Cleansing-Text-Formulas-with-Excel-2010.html]

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I'm looking for a text formula or VBA code for removing any text between brackets. For example, the following text: <br />
OMI (ANNEM) (DRAMA EDIT V.)<br />
<br />
should be corrected to:<br />
OMI<br />
<br />
Another text will have one set of brackets only like the folowing:<br />
LOONEY TUNES (RE-RUN)<br />
<br />
This also to be corrected to:<br />
LOONEY TUNES<br />
<br />
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.<br />
<br />
Thanks in advance for your help,<br />
Hani
</div>
</div>


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

Data Cleansing &amp; Text Formulas with Excel 2010

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

Data Cleansing &amp; Text Formulas with Excel 2010

Data Cleansing & Text Formulas with Excel 2010