I need to split a cell by the first delimter (reading right to left) so that I can put that value in another cell.
For Example, my data in cell A1 could look like:
"something - more something - a lot more of something - (this is the text I need)"
Cell B1 needs the value "(this is the text I need)"
so far what I have is:
=RIGHT(a1,LEN(FIND(RIGHT("-"),a1)))
but this seems to only return the last char: ")".