how to flip contents inside the cell of an excel?

[sidz832008]

Hi Folks.

I want to know how to flip contents within the cell of a excel sheet.

For example, Cell A1 contains the following:

Jan 20: Follow up with Gustavo conducted
Jan 25: Meeting with John held, no issues discussed.
Jan 30: Follow up commenced with VP's.


now, I want to flip contents of A1 so that the cell displays the following order of comments:



Jan 30: Follow up commenced with VP's.
Jan 25: Meeting with John held, no issues discussed.
Jan 20: Follow up with Gustavo conducted


Can someone please help me how to acheive this. thank you.


Sid

 

[GS]

Did you try using Sort?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Alex Plantema]

(e-mail address removed) schreef in

For example, Cell A1 contains the following:

Jan 20: Follow up with Gustavo conducted
Jan 25: Meeting with John held, no issues discussed.
Jan 30: Follow up commenced with VP's.

now, I want to flip contents of A1 so that the cell displays the
following order of comments:

Jan 30: Follow up commenced with VP's.
Jan 25: Meeting with John held, no issues discussed.
Jan 20: Follow up with Gustavo conducted

You should organize your data differently: don't put more than one item in a cell instead of 6.
Then you can use standard methods to sort data.