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

=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" wrote in
message ...

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

try

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

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=517528

=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