I am trying to extract a specific text from a cell with text up to the first delimiter from its left i.e.
(Green Tuesday)-(Yellow Monday)-(Black Friday)(Sunny Sunday)-(Purple Wednesday)
I would like to search for '(Sunny Sunday)' and the text up to the first delimiter ('-') from its left so resulting in
(Black Friday)(Sunny Sunday)
I have searched here but could not find anything that fit my query.
Thanks
Bookmarks