Sort Order is Mixed-Up

[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.

 

[Trevor Shuttleworth]

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

 

[Clueless in Seattle]

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"

 

[Trevor Shuttleworth]

You're welcome. Thanks for the feedback

Bingo!

Many thanks!!

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