sort cells with spaces to the top
 

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'
been able to get it to work. Hoping there is something I can d
programically.

Thanks,
Robi

--
stratagur
-----------------------------------------------------------------------
strataguru's Profile: http://www.excelforum.com/member.php...nfo&userid=131
View this thread: http://www.excelforum.com/showthread.php?threadid=26708

sort cells with spaces to the top
 

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