Sort Order is Mixed-Up

  • Thread starter Thread starter Clueless in Seattle
  • Start date Start date
C

Clueless in Seattle

I use an Excel 2003 worksheet for storing the results of my medical lab
results.

One of the columns is labled "Component" and contains the names of the
tests.

I have formatted the cells in this column as text.

I also have a column for the dates of the tests.

When I try to sort by Component, the rows don't end up in alphabetical
order.

Rows 2-13 are sorted alphabetically from CORTISOL to SODIUM

And then it starts over and rows 14-70 are sorted alphabetically
ADDITIONAL FINDINGS to VITD-25 OH

I'd be grateful for some ideas on how to troubleshoot and solve this
problem.
 
Is it possible that you have a space character in front of some of the data?
That may not be immediately obvious but would explain the grouping. Perhaps
the data has been imported from somewhere else ?

Regards

Trevor
 
Trevor said:
Is it possible that you have a space character in front of some of the data?
That may not be immediately obvious but would explain the grouping. Perhaps
the data has been imported from somewhere else ?

Bingo!

Many thanks!!

Will in Seattle
a.k.a. "Clueless"
 
Back
Top