Sort

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

Hi,
Can you help with this problem please

I have a spreadsheet with data I copy from the web...
In column A I have Dates...

Wednesday April 2 2003
Saturday March 29 2003
Wednesday March 26 2003
Saturday March 22 2003


What I want to do is sort the dates as...

Saturday March 22 2003
Wednesday March 26 2003
Saturday March 29 2003
Wednesday April 2 2003

Thanks in advance,

Regards,
Eamon
 
Hi
probably these values are stored as text and not as real
date values. Try the following:
- format the column with the custom format 'DDDD MMMM D
YYYY'
- select an empty cell and copy this cell
- select your range of imported dates
- goto 'Edit - Paste Special' and choose 'Add'

Now try the sorting again
 
You'll need a helper column using the formula:

=MID(REPLACE(A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)
+1),,","),FIND(" ",A1)+1,255)*1

Then sort ascending based on this helper column.

HTH
Jason
Atlanta, GA
 
Hi,
Jason & Mark

I am getting #VALUE,

Frank, does not appear to work Excel 2002

Regards,

Eamon
 
Back
Top