Get max characters in cell in 1 column

  • Thread starter Thread starter fbonilla
  • Start date Start date
F

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.
 
=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)
 
=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.
 
Back
Top