P.S. -

If you want the longest entry in a range of cells to be
returned in a formula:

Array entered with the key combo of CTRL,SHIFT,ENTER:

=INDEX(A1:A100,MATCH(TRUE,LEN(A1:A100)=MAX(LEN
(A1:A100)),0))

If more than one cell contains the longest entry the
formula will return the first instance of the longest
entry.

Biff

-----Original Message-----
Hi. What is the best / quickest way to find the longest
entry (most
characters / numbers, etc.) in a column? Thanks.
.