You’re getting that result because the formula is actually finding the first instance of
>, not the last one. I would recommend using the
MID function like the following:
This formula uses one FIND function to identify the first instance of
>, while the second function uses that location (+1) as the starting point for the
MID function. The
500 at the end is how many characters you want to return after
>; it’s just set arbitrarily high to account for longer text strings, so you can adjust as needed.