It should work, with cells with 1 space 1st, then 2 spaces, etc. But remember
that text is sorted after numbers. If some of your cells contain numbers,
they'll be at the top. You would need to set up a formula in a "helper" column
that manipulates the data in the cells so it will sort correctly.

On Wed, 6 Oct 2004 18:17:21 -0500, strataguru
wrote:


Hi,

I'd like to sort rows to the top if the value in a cell is spaces?
I've tried numerous options with the sort inside of Excel - but haven't
been able to get it to work. Hoping there is something I can do
programically.

Thanks,
Robin