Thread: How can I determine the largest physical size cell in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default How can I determine the largest physical size cell in a column
=MAX(LEN(A1:A1000))
Array formula, to be validated with Ctrl+Shift+Enter


HTH
--
AP

"csa001" a écrit dans le message de news:
...
Have a worksheet in which I need to know the largest size item in each
column, text coulmns only.


Reply With QuoteReply With Quote