Excel always sorts blanks at the end. If blanks are sorted before text
, then the cell values may not actually be blank but may contain spaces
which is regarded as text by Excel and sorted first. To overcome this,
select the empty cells and press blank cells.
To make sure the cells are blanks, press CTRL+G -Special-Blanks and
give OK. If your cells are really blank then they would be
automatically selected.

For more on finding cells that contain specific values, visit this post
http://xlmaster.blogspot.com/2006/08/edit-menu.thml

Robbie wrote:
I have a database some 10 columns wide and 1200 rows deep. When I sort by
one particular column it sorts BLANKS before text meaning that the data
appears at the bottom of the database although still in alphabetical order.

I have the formatting set to GENERAL for the whole column and do want the
blank cells. None of the other columns do this. I am totally perplexed as I
thought Excel sorted blanks nearer the end of it's priority.

I have tried formatting the column to TEXT and even NUMBER also but it still
makes the data appear at the bottom of the table. This doesn't make any
sense to me...HELP,

Thanks for any help in advance.

Robbie