How to use a ConditionalTextOperator in ExcelScript

Josie 1 Reputation point
2022-04-19T15:32:02.947+00:00

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!

JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
932 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,698 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Brian Gonzalez 76 Reputation points
    2022-04-21T16:06:26.983+00:00

    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.)

    0 comments No comments