Hi,
I am looking to extract the words "importance 8" from the below text.
abcd: alert #12345, start 2020-08-11 23:00:00 GMT, count 300, stop 2020-08-11 23:11:00 GMT, importance 8, parent, is not done)
The formula should pick all the strings starting with first word "importance" and second-word "parent"
I am using the formula =MID(A2,SEARCH("GMT,",A2)+4,SEARCH("parent",A2)-SEARCH("GMT,",A2)-5) but since the GMT word is getting repeated twice it is giving the result as " count 300, stop 2020-08-11 23:11:00 GMT, importance 8, " instead of the desired result.
Please help me.
Thanks!
Bookmarks