LEN formula excludes line feed?

Thanks a lot Norie! I liked the approach too!! Cheers!

Originally Posted by Norie

To count the no of CHAR(10) in a string:

Formula:

=LEN(A2)-LEN(SUBSTITUTE(A2, CHAR(10),""))

Or in code.

NoChar10 = Len(Range("A2"))-Len(Replace(Range("A2"), Chr(10),""))