With strings in A4:A99, try
Formula:
=INDEX(A4:A99,MATCH(MAX(INDEX(LEN(A4:A99),0)),INDEX(LEN(A4:A99),0),0))
The 2nd and 3rd INDEX calls should allow you to avoid array formula entry. However, you could shorten this to
Formula:
=INDEX(A4:A99,MATCH(MAX(LEN(A4:A99)),LEN(A4:A99),0))
as an array formula, so typing this formula then holding down [Ctrl] and [Shift] keys before pressing [Enter].
Bookmarks