Thanks, Chip. I thought that might be part of it; but I didn't know if
there were others that everybody but me knew about <g

By the way, =SUM(LEN(1:1))=0, array entered, will return TRUE or FALSE,
depending on whether the entire row is or isn't blank.

Alan Beban

Chip Pearson wrote:
Alan,

I believe he's talking about the ' used at the beginning of a cell's data.