Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I import daily a large database into Excel.. The data is contained in 20
columns and it is required that I sort in date and time order I have "Deadline:20:40 26/6 Overdue" in A1 MID(A1,16,5) brings "26/6" in B1 MID(A1,10,5) brings "20:40" in C1 B1&C1 brings "26/6 20:40" in D1 Copy and Special Paste (Values) from D1 brings "26/6 20:40" in E1 I can them delete cols A to D (I need the space) and sort on col A, which was previously col E This is very time consuming - ia there any way I can do this in fewer "steps"? Thanks in advance. |