How to get last words by formula

[vics_roo]

Good day

I need take last words from cells.

as example

in cell A2 I have text

"word1 / word2 word3/ word4 /word5/word6 word7"

In cell B2 I need get

"word6 word7"

I can do it by VBA, but now I need to get it by formula. How I can get it ?

Thanks at advance

 

[Aladin Akyurek]

Try...

=REPLACE(A2,1,FIND("#",SUBSTITUTE(A2,"/","#",LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))),"")

 

[Rick Rothstein]

Your text looks like a file path. Given that, you should be able to use this formula...

=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",300)),300))