The "blank" cells may actually have something in them that brings them to the top.
They may contain invisible formatting characters or empty text "" (as the result of a formula).
Data from a foreign source (not you) should be cleaned before trying to work with it.

To automate the sorting of multiple individual rows (across) you will need to use a
macro or a commercial sorting utility.
--
Jim Cone
Portland, Oregon USA
)
3 week free trial of "Special Sort" - just ask for it.




"DayleMSCU"
wrote in message ...
I'm trying to sort each row. Each contains differing numbers of cell entries,
anywhere from 1 to 24. I've done a custom sort by selecting only the cells
containing data on each row then custom sorting etc, but I have over 2,300
individual rows to sort.
I also have problems with the blank cells. If I highlight a whole row they
seem to get placed first in the sort on each row.

The data in each cell starts with numbers like this: 01, 02, 03, 04, etc
with an author's name after, eg. 06 SMITH DM. It's the order of authors for
academic texts, so order is vital. All cells are formatted as numbers.
Hope someone can help.