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

[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

 

[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

 

[MichaelS_]

Thank you very much for your help. My problem is solved.

Michae