Is there a formula that will return the number of characters for the cell with the most characters in a column?
For example, if my column is:
a
aa
a
aaaa
a
aaaaa
a
The formula should return "5" since there are 5 characters in the cell with the most characters.
I know I can right-click on a column and choose "column width," but that number doesn't always equal the number of the most characters.
thanks,
mike.
Edited by diggeryo, 09 December 2009 - 11:17 AM.