Reorder cell contents in reverse order - YIKES!!! quick resolution required!!

[ShuStar]

Hi all,

Got a sticky situation that is stressing me out, so need expert help!!

I need to change the cell contents in reverse order - kind of sorting the cell Z-A but by line.

I want to reverse the cell layout so that the latest comment is at the top. ie Comment 5 followed by 4,3,2,1
(the comments at the bottom of the cell from my extract is the Latest comment, therefore would like this to show at the top).

There can be more than 5 comments, this is only an example*Essentially I want to reverse the content in the cell by line, re ordering the cell by Comment 5,4,3,2,1
*I guess its like Sorting the cell Z-A but by line
*I would like the easiest way to do this, prefereably by formula but if there is a macro, then this is fine.
*If the resolution will get too messy (as there can be more than 5 comments), then if is there a way to extract the last 3 latest comments, then I am happy with this....(ie Comments 5,4,3 and in the order so that Comment 5 is at the top, followed by 4 and 3)

I am open to ideas, ie formulas split across columns and then concatonated etc

Hope this makes sense. An example of what I am facing and the format I'd like it is below.

Thanks in advance!!!
[TABLE="width: 413"]
<tbody>[TR]
[TD]Product ID
[/TD]
[TD]Comments Column Currently
[/TD]
[TD]Ideal Comment Layout
[/TD]
[/TR]
[TR]
[TD]QQ
[/TD]
[TD]Comment 1
Comment 2
Comment 3
Comment 4
Comment 5
[/TD]
[TD]Comment 5
Comment 4
Comment 3
Comment 2
Comment 1
[/TD]
[/TR]
[TR]
[TD]AA
[/TD]
[TD]Comment 1
Comment 2
Comment 3
[/TD]
[TD]Comment 3
Comment 2
Comment 1
[/TD]
[/TR]
[TR]
[TD]ZZ
[/TD]
[TD]Comment 1
Comment 2
Comment 3
Comment 4
[/TD]
[TD]Comment 4
Comment 3
Comment 2
Comment 1
[/TD]
[/TR]
[TR]
[TD]WW
[/TD]
[TD]Comment 1
Comment 2
[/TD]
[TD]Comment 2
Comment 1
[/TD]
[/TR]
</tbody>[/TABLE]

 

[ShuStar]

Hi Rick,

I have just tested your code - IT WORKS!!!!

Many thanks!!!!!!!!!



svendiamond - thanks for your help aswel. Although i do not need the code u presented earlier, I definately have a feeling that it will come handy soon!!

Guys, honestly thank you very much for your help!!!

 

[ShuStar]

Thank you everyone for your help!!!!

It is greatly appreciated.

Ricks code works really well so probably will do with this.

Cant stress how much I appreciate everyones support on this, thank you!

 

[ShuStar]

Apologies Rick, really sorry, i thought if I only mentioned the key columns and then modified the code, it would be the easiest way, every coder has their own way of coding etc so thought id keep it as simple as possible and modify on my side if necessary... but i can understand your frustration, will bear this in mind for future reference.... once again Rick and everyone else - thank you very much!