Descending sort instead of the way it is now

[jm594]

Hello everyone,
I have a spreadsheet created by a co-worker and in one cell there are many tracking entries like the one example shown below.
Notice that is sorted in ascending order but only because that is the order that the entries have been entered. Now an understandable request has been made to show them in descending order. This is so people can see the most recent entries first. Aside from the fact that it should've been set up this way from the beginning, is there a fast way that I can go through and resort this information in descending order? I tried dumping it out to Word and doing a sort there but that did not work. Thanks for the help.

Example of what is entered into a single cell is shown below:

1/17/19: Zelda set up meetings to proceed. Socializations scheduled.
2/14/19: Cell Coverage Strength Testing would fall more into Investigate Process and the Pilot MAY fall toward the end of the warranty period (or later). CM requested Edward track the possible change from XYZ Ops. Process hand-off will move forward.
2/28/19 - ABC/XYZ training coordination still being worked on by AB
4/25/19: Implementation started. Issue related to removal of a meter w/o customer notification is to be addressed with emphasis to TTT. (Note: JKL: Abigail HIJ, Bertha is interim KLM Supv,)
5.9.19 - Tim to meet with Alex & Frank Z. to determine if cell coverage check will part of this process version. Met on 5/29 - determined to include RSSI check (cell coverage) using what we used before. Kirby to email Charles Doman for content for job aid. MNO to add note to step when cell coverage check should occur.
6.5.19 - Scope refinement in 999 resulted in output process activity change to this process. Meeting set for 6.6.19 to make warranty changes to include Received Signal Strength Indication (RSSI) checking.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[modytrane]

See attached file.
I pasted your data in to Excel and it copied each entry in a separate cell.
Then I split the data in two columns. Copied that data in other columns and sorted it in reverse order.

If you can attach your excel file, I can look at it and offer specific help for your file.

Hope this helps.

Formulas used to split data:

And

[shg]

What if some of the dates had two-digit months?

[jm594]

I followed your instructions. When you open the attached spreadsheet you will see a Before and After tab. Notice that everything that I want to sort is in one cell. I'm starting with a bunch of cells that look like the Before spreadsheet. Someone has made a bunch of entries in the cell and placed a date before each entry. I want to somehow reverse this sort so it looks like the After spreadsheet.

[torachan]

Using your example file, you stated you wanted the entry order reversed.
Therefore I ignored the date and concentrated on the entry order.
The two attached files have a macro/VBA fired by on sheet button.
One file will reverse the order all within one cell and can be 'flip/flop' repeated.
The other file reverses the order and puts each individual entry into its own cell (this is a one-off action).
torachan.

[torachan]

After a re-read of your post I have copy/paste from your first post #1
Into both versions and that data also appears to extract and reverse OK.
As only your examples to work with you may have to adjust the code to accommodate number of entries per cell.
torachan.