Sort when I have blank cells

[C. Corodan]

Hello,

I am trying to sort ascending a range containing blank cells. After sorting,
the blank cells will be displayed on top and the cells woth text at the end.

e.g, if I sort column A1:A10, I get B1:B10.

A B C
1 1
3 2
3
4 4
2 1 5
2 6
3
6 4
5
5 6


What should I do to hace an ascending sorted range displaying the cells with
text first and the empty cells at the bottom, as in C1:C10?

Thanks,

 

[Dave Peterson]

When I sorted a list of numbers, they always moved to the top.

If I sorted text, then all the really empty cells moved to the bottom. But the
cells that weren't empty, but still looked blank (evaluated to ="" or a
contained a space character) would sort to the top.

So you could clean up those cells that look blank by hitting the delete key and
really making them empty.

Or you could add a helper column and use a formula that would plop in a value
that would sort to the bottom. Then you could sort by that.

=if(a1="","zzzzzzzzzzzz",a1)