View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default 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))