Articles

Formula

Dropping the first character

Keep every character after the first in a text cell, using RIGHT and a length of LEN minus one.

Concept

What #DIV/0!, #N/A, #VALUE!, and #REF! mean

Read what #DIV/0!, #N/A, #VALUE!, and #REF! mean when Excel shows one of those values in a cell.

Comparison

When COUNT and COUNTA differ

Choose COUNT for a tally of numbers only, and COUNTA for a tally of every cell that is not empty.