MAX and LEN in single cell

[Steve]

I prepare many mailing lists and am looking for a quicker
way to analyze a list. So far, I'm using a macro to add
columns and rows. . .then inserting a len field on the
inserted column. Then putting MAX at the top of each
column.

What I would like to do is simply add a row at the top of
each column with a statement like this:

MAX(LEN(A1:a1000)

.. . .although this does not work. It's requiring the LEN
field to be in each individual cell. Any easier
workaround ideas? TIA -Steve

 

[Peo Sjoblom]

Are you looking for to know which cell has the longest string or just want
to know how long
the longest string is. If the latter you can use

=MAX(LEN(A1:A1000))

entered with ctrl + shift & enter

if you want to know what the longest string is

=INDEX(A1:A1000,MATCH(MAX(LEN(A1:A1000)),LEN(A1:A1000),0))

entered with ctrl + shift & enter