Mar 16 2022 01:25 PM
Mar 16 2022 02:05 PM
Let's say that you have such a text string in A2.
The following formula will extract the text you want:
=MID(A2,7,FIND("@",SUBSTITUTE(A2,"-","@",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))-7)
In this formula, @ is just a character that doesn't occur in the text string. If your text string might contain @, simply replace @ with a character that will not occur, for example |
Mar 16 2022 02:18 PM
Mar 16 2022 02:24 PM
That would be
=MID(A2,FIND("FOUND_",A2)+6,FIND("@",SUBSTITUTE(A2,"-","@",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))-FIND("FOUND_",A2)-6)
If FOUND_ could be in upper case or lower case (or mixed case), use
=MID(A2,SEARCH("FOUND_",A2)+6,FIND("@",SUBSTITUTE(A2,"-","@",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))-SEARCH("FOUND_",A2)-6)