INFORMATICS

The Best

Count line breaks in cell

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

To count total lines in a cell, you can use a formula based on the LEN, SUBSTITUTE, and CHAR functions.

In the example shown, the formula in A1 is:

=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),""))+1

Search