Is it possible to move the first few letters in a string to the end of a cell in Excel? So if I have a number of cells with something like this in them:

women/colour/type


Is it possible to ask excel to move the women part to the end of the cell? e.g.

colour/type/women


I could really do with some help on this.

Thanks in advance
This is a little bit of a hack but try the following assuming the field you want to evaluate is at A1:

=MID(A1,FIND("/",A1,1)+1,LEN(RIGHT(A1, FIND("/",A1,1)))-1)&amp;"/"&amp; RIGHT(A1, FIND("/",A1,1)-2)&amp;"/"&amp; LEFT(A1, FIND("/",A1,1)-1)


This is broken down into three parts (split by the &amp;"/"&amp;):


Left: =LEFT(A1, FIND("/",A1,1)-1) returns woman  
Middle:=MID(A1,FIND("/",A1,1)+1,LEN(RIGHT(A1, FIND("/",A1,1)))-1)returns
colour  
Right: =RIGHT(A1, FIND("/",A1,1)-2) returns type  


Put the parts into the new order add the &amp;"/"&amp; dividers back in and voila.