How can I determine the largest physical size cell in a column

[csa001]

Have a worksheet in which I need to know the largest size item in each
column, text coulmns only.

[SteveG]

Do you mean the highest number of characters?

Try,

=MAX(LEN(A1:A100))

This is an array formula so commit with Ctrl-Shift-Enter not just enter. It should look like this after commiting,

{=MAX(LEN(A1:A100))}


Does that help?

Steve

[Ardus Petus]

=MAX(LEN(A1:A1000))
Array formula, to be validated with Ctrl+Shift+Enter


HTH
--
AP

"csa001" <[email protected]> a écrit dans le message de news:
[email protected]...
> Have a worksheet in which I need to know the largest size item in each
> column, text coulmns only.