I have data in column A looks like this "abc def (xxx: yyy zzzz)"
What I want to do is to search every cell in column A and truncate the data after "(xxx:" as "yyy zzzz)" is variable and "(xxx:" is constant.
Could anybody help me out. Thanks in advance.
Bookmarks