It has some reasonable use-cases when dealing with text, the problem is that it’s extremely easy for idiots to misuse it, either by trying to do math or by not supplying any cells in the optional second argument.
Not requiring the second argument was nuts, and it should probably have refused any query resulting in a number as well.
It has some reasonable use-cases when dealing with text, the problem is that it’s extremely easy for idiots to misuse it, either by trying to do math or by not supplying any cells in the optional second argument.
Not requiring the second argument was nuts, and it should probably have refused any query resulting in a number as well.
Ah yes, those idiots trying to do math in Excel.
Or trying to do text in excel?!