You don't need VBA for that. Just search for: -*\) and replace with nothing.