[Solved] Remove any instances of "(integer)" from a cell

[cul]

Hi, is it possible to use a formula to remove all instances of an integer within 2 brackets (and the brackets themselves)?

such that
Todd Terje
Cortex (6)
Hanna (24) / Almir Ricardi
A.A.L. (Against All Logic)
Leon Vynehall

appears as
Todd Terje
Cortex
Hanna / Almir Ricardi
A.A.L. (Against All Logic)
Leon Vynehall

Thanks for any help!

[FJCC]

You can do this with Find & Replace. Highlight all of the cells you want to affect then select the menu item Edit -> Find & Replace. In the Search For box enter

Code: Select all

\(\d+\)

Leave the Replace With box empty. Click on More Options and select Regular Expressions and Current Selection Only. Click Replace All and you should be done.
Make sure you save a copy of the document in case something goes wrong.

[cul]

Great, that worked. I would prefer to add a formula to a cell - so that I don't have to refer back to this post every week - but this absolutely gets the job done. Thank you.

[RusselB]

You can use the regex (the code provided by FJCC) as the search parameter in the SUBSTITUTE function.
See the help file for more information about this function.

[cul]

Perfect, thank you.