Hi all
I have a group of strings of varying length like this,at the end there parentheses() with again varying length strings seperated by a -.
Here are three random examples:
the cat sat on the mat(aa-bb)
the birds fly away in winter and who can blame them(a-ccc)
trouble at mill(cc-eeffgg)
I am trying to find a way (in vba or an XL function) to get rid of the parentheses themsleves() and the content of the parenthesis and just leave the remaining string.
Any help much appreciated.
Kind Regards
BIF
Bookmarks