Get max characters in cell in 1 column

[fbonilla]

I am trying to figure out how to get the max charcters in a column.

So if I have ten items in one column, I want to be able to put a formula or run a macro that will count the total number of characters in each cell and then return the max number.

thanks in advance.

[tony h]

try

=Len(B3)
=len("abc")

regards

[Bob Phillips]

=MAX(LEN(A1:A100))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"fbonilla" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to figure out how to get the max charcters in a column.
>
> So if I have ten items in one column, I want to be able to put a
> formula or run a macro that will count the total number of characters
> in each cell and then return the max number.
>
> thanks in advance.
>
>
> --
> fbonilla
> ------------------------------------------------------------------------
> fbonilla's Profile:
http://www.excelforum.com/member.php...o&userid=32011
> View this thread: http://www.excelforum.com/showthread...hreadid=517528
>

[Dave Peterson]

=MAX(LEN(A1:A20))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

fbonilla wrote:
>
> I am trying to figure out how to get the max charcters in a column.
>
> So if I have ten items in one column, I want to be able to put a
> formula or run a macro that will count the total number of characters
> in each cell and then return the max number.
>
> thanks in advance.
>
> --
> fbonilla
> ------------------------------------------------------------------------
> fbonilla's Profile: http://www.excelforum.com/member.php...o&userid=32011
> View this thread: http://www.excelforum.com/showthread...hreadid=517528

--

Dave Peterson