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)&"/"& RIGHT(A1, FIND("/",A1,1)-2)&"/"& LEFT(A1, FIND("/",A1,1)-1)
This is broken down into three parts (split by the &"/"&
):
- 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 &"/"&
dividers back in and voila.