how to move blank entries to the end of the list in a A to Z sort?

[jdmc45]

How do I move the blank entries to the end (instead of the start) in a A to Z sort?

Cheers!

 

[Tom Urtis]

They should be doing that already by default. Maybe your "blank" cells are actually not empty, if you have formulas in them returning null strings, or they contain invisible characters like spacebars.

 

[jdmc45]

Hi,

Yes you are right, they are null strings, is there a way to have the null strings at the end of the sort?

 

[Tom Urtis]

Without knowing what column you are primarily sorting because you have not said, let's say it is column B.

The cells are NOT blank as they contain "" (empty text). Use a hidden column to sort by in your sort criteria. Example:
=IF(B1="","ZZZZ",B1) where Column "B" houses your formulas. "Z" is the last alphanumeric character in the hierarchy chain, and four Z's should ensure the returned value is not like any other bona fide value.

 

[jdmc45]

Thanks for your help