Forum Discussion
Can i use FIND to search last occurence
So I have a string Complete Status 123@2023-03-01T16:25:51.094Z Status 456@2023-03-01T16:22:46.227Z| Status XYZ@2023-03-01T19:43:56.184Z Status 456@2023-02-28T18:24:23.7292| Status XYZ@2023-02-...
With such a string in A1:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1, "@", REPT(" ", 255)), 255)), "T", " "), "Z", ""), "|", "")-5/24
Format as date + time.