sort cells with spaces to the top

  • Thread starter Thread starter strataguru
  • Start date Start date
S

strataguru

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pictures not being sorted in VBA 2
Add Space Padding 2
Color sort - any cell in row that has colorindex = 4 7
sort duplicates in string 2
Clear "Blank" cells 8
Excel VBA help: Text file formatting 19
help with sort on active cell 3
Sort partially hidden data 1

Back
Top