How to use a ConditionalTextOperator in ExcelScript

Question

I am new to ExcelScript and trying to write a script that determines whether a cell contains a space. I'm not sure how to use the ExcelScript.ConditionalTextOperator enum. I know there is a "contains" value, but what do I use with this operator object to find a space? Is there a boolean function that takes it as a parameter? Thanks!

Answer 1

Are you trying to see whether a cell contains any spaces? Or are you trying to see if a cell contains spaces in certain situations (e.g. leading spaces, trailing spaces, a space if the cell appears to be empty, etc.)