extract last part of a text string

Originally Posted by NBVC

Try:

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,">", REPT(" ",LEN(A1))),LEN(A1)),LEN(A1)))

It works great. Thank you very much