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.

Try Recording a Macro while doing the process one more time.......then just
run the macro in the future to do it all for you automatically.......

hth
Vaya con Dios,
Chuck, CABGx3



"SouthAfricanStan" wrote:

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.