sort not working

  • Thread starter Thread starter stevemalee
  • Start date Start date
S

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"
 
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...
 
You must have checked the header row option in mydata range....so firs
uncheck the option and then try once again




Chris
 
Back
Top