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