Sorting text within a cell (by date)

[NickGB]

Hi

I have a column with multiple rows and within each row there are a whole load of comments. What I need to do is sort the comments in descending order.

An example of CELL(D8)

16/06/2015:LKelly: ,16/06/2015:LKelly:Email sent to see how he wishes for us to proceed regarding fees. ,18/06/2015:LKelly: replied that we are to Escrow for the requested fees by the SPA. ,18/06/2015:LKelly:Escrow form sent for approval of SPA fees ,10/04/2015:MWilliams:The 2-metre four port antenna may be shown as the standard antenna where the antennas require replacement. ,27/04/2015:LKelly:This Lease is in term until 28/7/2024. ,27/04/2015:LKelly:Further PO necessary for Full Rights Required. ,12/05/2015:LKelly:Letter 6 and Consent Forms sent to SPs today via Recorded Delivery along with stamped, addressed envelopes for return.

<tbody>
</tbody>

As you can see the date order is not correct and this is a completely separate issue I have with the mysql developer.

Is there a simple way to sort the cell itself? Have looked around the forum and found one which looked like it might work but unfortunately didn't.

Thanks

Nick

 

[hiker95]

NickGB,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

Have looked around the forum and found one which looked like it might work but unfortunately didn't.

I do have an idea on how to do what you have requested, but:

Can you post a link to the thread you mentioned above?

 

[NickGB]

Hi Hiker,

Excle 2013 and Windows 8.1 pro

http://www.mrexcel.com/forum/excel-questions/208368-sort-text-cell.html

Cheers

Nick

 

[hiker95]

NickGB,

Thanks for the link, but, it did not help.

I have a column with multiple rows and within each row there are a whole load of comments.

1. So the cells with the comments are in column D, beginning in cell D8, and, going down to the last used cell in column D?

2. Do all the cells with comments have the same structure/delimiters as cell D8?

 

[hiker95]

NickGB,

Excel 2007
	D
8	16/06/2015:LKelly: ,16/06/2015:LKelly:Email sent to see how he wishes for us to proceed regarding fees. ,18/06/2015:LKelly: replied that we are to Escrow for the requested fees by the SPA. ,18/06/2015:LKelly:Escrow form sent for approval of SPA fees ,10/04/2015:MWilliams:The 2-metre four port antenna may be shown as the standard antenna where the antennas require replacement. ,27/04/2015:LKelly:This Lease is in term until 28/7/2024. ,27/04/2015:LKelly:Further PO necessary for Full Rights Required. ,12/05/2015:LKelly:Letter 6 and Consent Forms sent to SPs today via Recorded Delivery along with stamped, addressed envelopes for return.
Sheet1

Can I see what the results should look like (manually formatted by you) of the above cell screenshot?

 

[NickGB]

Hi Hiker - Sorry for the delayed response!

,10/04/2015:MWilliams:The 2-metre four port antenna may be shown as the standard antenna where the antennas require replacement.
,27/04/2015:LKelly:This Lease is in term until 28/7/2024.
,27/04/2015:LKelly:Further PO necessary for Full Rights Required.
,12/05/2015:LKelly:Letter 6 and Consent Forms sent to SPs today via Recorded Delivery along with stamped, addressed envelopes for return.
16/06/2015:LKelly:
,16/06/2015:LKelly:Email sent to see how he wishes for us to proceed regarding fees.
,18/06/2015:LKelly: replied that we are to Escrow for the requested fees by the SPA.
,18/06/2015:LKelly:Escrow form sent for approval of SPA fees

The comma's are from the database but not essential...

Cheers

Nick

 

[hiker95]

NickGB,

Sorry for the delay in responding.

I have not been able to create the results that you are looking for.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.