Hi, I'm struggling with finding the right formula to use. I have a cell that contains a great deal of information. I want to pull the date and time after the word STOP in the below example. As you can see the word STOP appears twice and so I would need to pull the date and time after each word STOP. My return should be 01/06 11:03 01/07 10:29. Nothing I have tried seems to do the trick. Any help would be hugely appreciated.
|STOP@01/06 11:03 (USER96639)|
FLAT@01/06 12:03 (USER96639)
FLAT@01/06 14:26 (USER96639)
STOP@01/07 09:01 (USER96639)
FLAT@01/07 10:29 USER(USER96639)