2

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

4
  • 1
    Even better can you put the data into separate cells so women colour and type are in separate columns
    – mmmmmm
    Commented Aug 1, 2013 at 10:49
  • Actually no not at the moment it is for some work I am doing SEO wise and it is for categorisation of products. Unfortunately
    – John E
    Commented Aug 1, 2013 at 10:53
  • Not really the question you're asking here, but Mark has the right idea. If you separate your data out into different columns, you'll need to adjust your analysis to accommodate (in the short term), but should later find that it will provide a much more flexible way to access the data.
    – Scot
    Commented Aug 1, 2013 at 19:50
  • 1
    At a minimum - you'll find it much easier to put your data together in any order you like if you split it up, using the concatenate function in Excel.
    – Scot
    Commented Aug 1, 2013 at 23:00

1 Answer 1

2

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .