sorting

[Pam]

I have a spreadsheet with a header row that goes a-p and I
have 1786 rows. In column A which the header is Section
some are blank, when I sort, by column a in ascending
order it doesn't give me all the blank, some are at the
bottom. When I sort in decending order all the blanks
appear at the bottom. I even copied column and then did a
paste special and chose values but it still breaks them up
in ascending order. What am I doing wrong. The column is
formatted at general.

thanks,

 

[Dave Peterson]

Are your blank cells really blank?

Do they have spacebars in them? Or maybe that HTML non-breaking space?

David McRitchie has a macro that cleans up this kind of thing.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm