Sort

[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

 

[Frank Kabel]

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

 

[Jason Morin]

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

 

[Eamon]

Hi,
Jason & Mark

I am getting #VALUE,

Frank, does not appear to work Excel 2002

Regards,

Eamon