Search code examples
stringexcelreplaceexcel-formulaworksheet-function

Removing few characters from a string using wild card


emphasized text

https://i.sstatic.net/TmzRL.jpg

I used string function but the result becomes skewed if the number of digits in parentheses varies.

How do I sort this issue?


Solution

  • Find & Select seems quite up to the task:

    SO33638050 example