Max Length in a row
"Commish" wrote:
I am trying to find a formula or a quicker way to get
the length of the largest value in a row of text values.
[....]
I can use the LEN function to get the length [...].
I've got 30+ columns
By "largest", I assume you mean "longest".
Enter the following array-entered formula (press ctrl+shift+Enter instead of
just Enter):
=max(len(a1:ad1))
|