Replace Words from end to beginning

[BCus]

Hey MrExcel !

i have a question about replacing over 1700+ rows words..
this is what needs to be done basicly;

row1: word1/word2/word3/word4

I want to replace the words in this way, note the numbers;

word4/word2/word3

I want to replace word1 with word4, deleting word1 but keeping word4 at the beginning.

Actual word4 changes... the actual word is different on each row!
example:

row1: word1/word2/word3/apples
row2: word1/word2/word3/grapes
row3: word1/word2/word3/oranges

replace and removing the end forward slashes on each row:

row1: apples/word2/word3
row2: grapes/word2/word3
row3: oranges/word2/word3

Another scenario is to delete word1 on each row first, then just moving word4 to the beginning of the phrase and removing the forward slashes at the end.


Do you think this is possible ?
I am using MS Excel 2010,

Cheers!

 

[BCus]

thank you so much!