View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Commish Commish is offline
external usenet poster
 
Posts: 14
Default Max Length in a row

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. Basically, it's a validation step in a large (1,000s of rows) table.

I can use the LEN function to get the length of any individual cell, or use a formula like =max(len(a1),max(b1),max(c1)). But I've got 30+ columns and would like to make it easier on the typing. Any thoughts/hints/tips?