Getting the longest lengh in range of cells

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

I am trying to get the length of the longest cell in a range and use the
array {=len(a1:a1)}. What happens is that it picks up the length of cell A1.
Is there a way in a formula to determine the longest cell length in a range,
or through VBA.

Thanks in advance
 
Hi
Try this formula array (please amend with last row number):
{=MAX(LEN(A1:A7))}

HTH
Cordially
Pascal
 
Back
Top