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