Sorting text within a cell (by date)

NickGB

New Member
Joined
Jan 2, 2013
Messages
22
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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?
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649

ADVERTISEMENT

NickGB,

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">8</td><td style="color: #574123;;">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.</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

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

NickGB

New Member
Joined
Jan 2, 2013
Messages
22
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,834
Messages
5,598,369
Members
414,233
Latest member
WolverineNurse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top