try

=max(LEN(C182:C189)) entered with Ctrl-Shift-Enter


"Little Pete" wrote:

Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?