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)"
also note; there could be dashes else where as follows:
"something - more -something - a lot more of something - (this is the text I need)"
Cell B1 needs the value
"something - more something - a lot more of something "
or
"something - more -something - a lot more of something
in the case of the seccond example
I asked the opposite of this question here: Split Excel Cell by last Delimiter (this question is not the same as the question that I am asking) which gave me the following formula:
=MID(A1,FIND("~~~~~",SUBSTITUTE(A1,"-","~~~~~",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,LEN(A1))
now I need to do the opposite of this.