how to flip contents inside the cell of an excel?

  • Thread starter Thread starter sidz832008
  • Start date Start date
S

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
 
(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
Click to expand...

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.
 
Back
Top