Sorting text within a cell (by date)

NickGB

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

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,


Excel 2007
D
816/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

New Member
Joined
Jan 2, 2013
Messages
25
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,459
Messages
5,831,756
Members
430,088
Latest member
meagerd

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