Your specification was:
Quote:
|
So I need a formula which can find and delete any string of characters between parentheses, but which also must contain a 4 digit number
|
The
wildcard Find/Replace code I posted does that.
If you only want to replace the first instance, use 'Replace', not 'Replace All'. And if you want the choice of which expressions to replace, click 'Find' to go to the first one, then 'Replace' if you want to replace it, else 'Find' to go to the next one. Continue, using 'Replace' or 'Find' each time, as appropriate.