Count the number of Lines in a "wrap text"-cell

M

MichaelS_

Hi

I try to count the number of Lines within a „wrap text“-cell. It woul
be nice to have a solution without VBA programming.

Tanks a lot for your help
Michae
 
B

Biff

Hi!

If the lines were created using CHAR(10) "hard returns" (key combo
ALT+ENTER) you could count those chars:

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

Have no idea how to do it if the cell was simply formatted to wrap text.

Biff
 
Top