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?
Bookmarks