View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Sort order on very large spreadsheet.

There may be leading spaces or non shown characters
try in a helper column
=trim(c1)
or clean(c1)
then try to sort on this column

"Dennis1188" wrote:

I have several cells that will not sort properly. Is there some kind of
setting that will prevent them from sorting from a to z.
When I manually enter some of the problem cells again in another workbook,
they sort fine.