Bingo. I found the apostrophes. Thanks Dave.

Is there any way of setting things up so ="" really equals blank? Cleaning
up is a pain.

"Dave Peterson" wrote:

Saved from a previous post:

If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab|Toggle Transition Navigation keys on.

Then select one of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)

When I want to clean up this detritus, I do this:

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all

hofberger wrote:

Adding headers and sorting with headers made no difference. When I sort, the
blank rows still show up at the top!!

Another clue - the blank rows look blank and there does not appear to be
anything in the cells - no values, no equations. If I highlight those blank
cells and hit delete (enen though there is apparently nothing there to
delete!!), the subsequent sort puts the blank lines at the bottom as it
should.

What is being deleted from the empty cells?

"Tevuna" wrote:

1) Add headers. And if Excel doesn't automatically detect..
2) Data, Sort, data has headers

--

Dave Peterson