TRIM change value type for <empty> cells


Is that normal that after a TRIM, an cell is converted in an empty string value.
No problem for me but it has an impact on filters if we don’t keep it in mind.
May I suggest to put a little reminder in the web-help about that.


Hello @cvo,

This is by design. All the test functions convert arguments that are expected to be text from their actual type to text.

We will think about how to mention this in the help.