Return longest string within cell

[Mlex889]

Hello Mr.Excel,

I need a way to return the longest string within a cell. (number of characters)
However, it should count strings based on line breaks within the cell.

For example,
==
This is an example
of text within one cell.
==

The above should return the value "24"

Thanks!!
Mike

 

[Mlex889]

Thanks, István. I recall now that you are something of an expert on the various forms of this construction!

Cheers

Thanks guys, you are the best.
That works!!
Mike

 

[XOR LX]

You're welcome!

Cheers