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:
What is the right way to do it?
[ A ]  aaa  bbbb  ccccc ---> MAX(LEN(A1:A3)) = 5
LibreOffice Calc 18.104.22.168 (x64), win10.