On Dec 10, 11:16 am, JE McGimpsey wrote:
Yes. The spacebar doesn't "clear" anything - it inserts space characters
in the cell.

And while merged cells are the spawn of the devil, and should never be
used, not even once, they aren't the problem in this case.

The formula I gave you works with "spaced", merged cells.

In article
,



wrote:
Yes, I have to clear using spacebar and 34 is merged with 35-are these
the problems?- Hide quoted text -

- Show quoted text -

Still confused. I'm getting a #NAME? result now. Even though I typed
in: 2 cs into 1 of the sheets cell. Any new suggestions?

Thanks