Select From right to left untill character is hit

I need to Select from the right all characters untill i hit a certain one.

example data is:
"Kitchens >> Appliances >> CDA Appliances >> Extractor Accessories" The result i want is "Extractor Accessories"

I have tried
"=RIGHT(CR3,LEN(CR3)-FIND(">>",CR3))"

but it does all characters untill the last occurence of > is found (or its actually finding the first occurence and checking from left to right)

This possible?

Try:

=TRIM(RIGHT(SUBSTITUTE(CR3,">>",REPT(" ",250)),250))

Originally Posted by Phuocam

Try:

=TRIM(RIGHT(SUBSTITUTE(CR3,">>",REPT(" ",250)),250))

Works perfect thankyou

You are welcome!