Need to Sort by Date & Alpha

Select the first row and make it color with any color. ( This is for justifying that shorting is correctly happen or not)

Now select the whole data then press Alt->S->S->>> in short by section select according which column you need to short the data ( If you have given header name the that same thing will shoe in short by section)->>>order you may select oldest to newest or newest to oldest as you need then ok.

Thats it, hope this will help you

Ok I am sorry i was thinking that Date and text both are in different cell but they are in same cell that is why it is not working.

You must do separate dates & text do follow below steps.

Select A1:A9 then press Alt-A->E Check mark delimited->>Check mark on space->>>Next->>Finish

Now select the both column A1:B9 the press Alt->S->S and do as in post #2 suggested.

Now You can simply add both cells into in one- =A1&B1

Hope this will help.

Hi all- Ankur, I tried ALT+s, ALT+S, ALT+FUNCTION+s. Nothing happened. Could you clarify your suggestion?
OK, ALT+E brings up Office Access Menu, asking for keys from older versions of Excel. Perhaps you could explain, without using Keyboard short-cuts?

Ok once again let me clear every thing.

You have data like
Header
22/02/2017 KT
20/04/2017 SA
21/04/2017 SA
23/05/2017 SA
24/04/2017 AD
26/05/2017 SA
30/03/2017 ST
31/03/2017 ST

The dates are with text, which mean you can't short them according Day,moths & year ( because cells are not date instead of date it has also text included)
So we must extract date in one column and text into next column (B)
For separation, you can use text to column function which is in built in excel and easy to use.

Select A1:A9 then press Alt->A->E Check mark delimited->>Check mark on space->>>Next->>Finish

This will extract date into A column and text into B Column.

Now you have dates which can easily short according your need.

Now select the whole data A1:B9 then press Alt->S->S->>> in short by section select according which column you need to short the data ( If you have given header name the that same thing will shoe in short by section)->>>order you may select oldest to newest or newest to oldest as you need then ok.

Data will short and now you just need to add them into single cell.

C1

Formula:

Please Login or Register  to view this content.

Drag down.

Hope now it is clear??

Originally Posted by leelnich

Hi all- Ankur, I tried ALT+s, ALT+S, ALT+FUNCTION+s. Nothing happened. Could you clarify your suggestion?
OK, ALT+E brings up Office Access Menu, asking for keys from older versions of Excel. Perhaps you could explain, without using Keyboard short-cuts?

@Leelnich If you will follow step by step according post #6 you will get it

I pressed ALT + E. Here's the result:
Untitled.png

Do you have KuTools or some other Add-In installed? Apparently ALT+E takes you to Text-to-Columns, but that's not built in to MY version of Excel 2016. I knew what you were doing, Ankur, I just thought you should clarify for the new guy.

Alt ->A-E sorry i missed A

OK, NOW it works. Hopefully @gamefreakad will be able to figure it out.
gamefreakad, If adding columns is a real problem, consider copying the problem data to a new sheet in cell A1 and down.
Split it up, sort it, paste Ankur's formula in column C to rejoin it, then copy column C and paste it AS VALUES in the original location.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee