excelvbams-officebulkoffice-2010

Excel - Bulk deletion of same words and rest of differing brackets content

I am compiling a glossary in excel, with entries coming from different sources. In the attempt to make it more uniform, I intend to delete the content of the "definition" rows indicating the field of usage of certain definitions.

My aim is to delete at once

(wordA wordB) 
(wordA wordC) 
(wordA wordD wordE)

from

(wordA wordB) text1
(wordA wordC) text2
(wordA wordD wordE) text3

in all rows, deleting also the space after the bracket but leaving

text1
text2
text3

untouched. Thank you in advance for any contribution. PS: my office version is 2010, but can get access to a PC with the latest version if required!

ADDITION Thank you very much for your contributions, but I forgot to add that some definitions have brackets containing useful information 

(wordA wordB) text1
(wordA wordC) text2
(wordA wordD wordE) text3
(wordA wordF) text4 (useful info between brackets) text

Hence I need to be able to retain everything contained in the cell, except for the content of brackets containing "wordA"

Solution

  • If your data looks like this:

    enter image description here

    You can use:

    =RIGHT(A1,LEN(A1)-FIND(") ",A1))

    to remove all the words before ") "

    I just have to share @Solar Mikes solution in the comment because it's amazing!!:

    In "Find and Replace" you enter in the field Find what: "(*)" (with a space after the last bracket)

    Because it will find anything in the bracket [* = wildcard] and replace that.

    And replace with "nothing" aka "".

    enter image description here

    Output will be this:

    enter image description here