UNSOLVED

SEMANA

updated

22 years ago

S

SEMANA

2 Intern

•

197 Posts

0

5509

November 25th, 2004 09:00

Sorting a two column table

I have a two column table in Word 2003.
 
In the first column I have the year, with the month following in parentheses like this:
 
Column One
 
2001 (March 3), 1997 (January 5) etc.
 
In the second column I have text.
 
When I sort the table by Column One, using either "Date" or "Number" I do not get a clean sort. I find some years in the right place and some not in the right place.
 
I've also tried using other date formats (e.g. 3/3/2001, March 3, 2001 etc.) but that doesn't work well either because in some cases the data have only the year or only the year and the month.
 
Any ideas?
 
Dimension 4550
1 GIG Ram
MS Office 2003
 
SEMANA

Message Edited by SEMANA on 11-25-2004 04:12 AM

  • joe_mcguire

    2 Intern

    •

    255 Posts

    369

    0

    Posted November 27th, 2004 02:00

    I am not sure what you mean by "some years in the right place and some not." I assume that you have only one entry (e.g. 2001 (March 3)) in each cell in Column 1. I made up a table with dates in that format and found that sorting by date did not work and that sorting numerically was inconsistent (Most of the years were sorted properly but one or two were not. I think the problem is the nature of the "field" as you have constructed it. Word will sort dates like March 3, 2001 but not 2001 (March 3). Without separators like tabs or commas, the entire entry is a single field; since it consists of both numbers and text Word is going to have problems since it can sort each field in only one way at a time. My guess is that even if you got the years sorted OK, sorting months alphabetically (in this format they are just text, the first of which would be April and the last September) is probably pointless. If you convert your dates to a format that Word uses, you may have a much better result.
  • SEMANA

    2 Intern

    •

    197 Posts

    369

    0

    Posted November 30th, 2004 15:00

    Thanks. I'll try that. I still don't see why Word won't sort the years (2001, 2003, 2004 etc.) as numbers. What if they weren't years, but just a series of numbers?
  • joe_mcguire

    2 Intern

    •

    255 Posts

    369

    0

    Posted November 30th, 2004 16:00

    Beats me, too. I am guessing that the "fields" it is sorting may be an issue.