Count number of non-empty lines in a multiline cell

[ch1zra]

Hello everyone,

I am having trouble with one of the sheets at work that is created and maintained in quite a bad manner.
It contains multiline cells but not all lines are containing text, some are just plan char(10).
What I need is a way to count number of lines that are non-empty.
I can get number of total lines using

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

but I am stuck on how to continue...

 

[ch1zra]

It is working, I have been counting empty lines instead of non-empties.
I guess only 3 hours of sleep in 40s is not the same as in 20s :D
Apologies for the mistake and once again huge thanks for the solution.

 

[Fluff]

You're welcome & thanks for the feedback.