Search code examples
excelreplacewildcardexcel-2008

Delete mutiple instances of variable strings within a single cell

If I have a cell looking something like this:

Ford Escort (ref 1234) , Ford Mondeo (ref 5588) , Suzuki Swift (ref kjgh) , John Holmes (hulubulu)

and want to remove all the parentheses and the information inside those but NOT all the information outside the parentheses. So I end up with:

Ford Escort , Ford Mondeo , Suzuki Swift , John Holmes

I found a way to use the MID() function, but this only removes the first parentheses with content (ref 1234) and I cannot seem to find a way to loop or repeat this function inside the same cell.

As it's different information in the different parentheses I cannot use SUBSTITUTE, but is there another way to do this in Mac Excel 2008 ?

Solution

  • Try Find what: (*), Replace with: nothing.