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

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


"stevemalee" wrote:

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

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




Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com