sort not working

[stevemalee]

I am trying to sort a column alphabetically, and the words are either 1 to 4
characters.

It will not sort alphabetically, and the 1 letter word always stays on the
top even though it is a letter "T"

 

[Sheeloo]

Only letter T remains on top and other rows sort properly?

In the sort dialog see that 'My data has header rows' is NOT checked and
then sort...

T might have a space after it... If it is in A1 then test with =LEN(A1) in
any cell... if the answer is more than one then edit it and delete the extra
characters...

 

[Chris Bode]

You must have checked the header row option in mydata range....so firs
uncheck the option and then try once again




Chris

 

[stevemalee]

Thanks for the help, I think the un-checking header will work