I am very new to VB, but I need a small macro that performs the following:
I select a number of cells, and then when I run the macro, it should look for text in brackets and delete it, including the brackets:
the car (2) provided with a roof (8 and 9) comprising
- a clutch (34) with a hand brake (3)
etc
should result in
the car provided with a roof comprising
- a clutch with a hand brake
I more or less managed to substitute a concrete text (for example "clutch") but here the macro has to look for "(" with
FIND("(";B10) and afterwards find the next bracket ")"
and then perform
REPLACE form "(" to ")" and replace it by ""
Could someone give me a hand?
Thanks.
Bookmarks