# CALC: Maximum Length of String in a Range of Cells

I have a very long column of strings and I need to find out what is the maximum length.

I thought that this will do the trick: ** =MAX(LEN(A1:A999))** but it doesn't work --> #VALUE.

In fact even this alone fails: `=LEN(A1:A999)`

as well as: `=SUM(LEN(A1:A999))`

.

What is the right way to do it?

Example:

```
[ A ]
[1] aaa
[2] bbbb
[3] ccccc
---> MAX(LEN(A1:A3)) = 5
```

LibreOffice Calc 6.4.3.2 (x64), win10.

Thanks.