Excel宏:高亮和删除文本。

I'm trying to put together an Excel Macro to eliminate a long series of repetitive keystrokes. I'm taking text in the form: "XXXXXXXX XXXXXXXX (XXXX XXXXX XXXXXXX)" And removing the bit at the end, making it: "XXXXXXXX XXXXXXXX"I'm trying to put together an Excel Macro to el