Showing results for 
Search instead for 
Did you mean: 

Trimming leading and trailing whitespace

DC Motor

This operation, when applied to a column, examines all rows for spaces at both the beginning and end of the text string. Where it finds them, they are removed—leaving only the value in the cell.

Note that numeric values are not subject to this function. This is because numbers are parsed upon import; they are not able to be stored with whitespace. Any spaces at the beginning or end of a value determined by the application to be number will have already been trimmed during upload.

To override this behavior, import settings must be adjusted during the import process. In the Import Options screen, the “Parse cell text into numbers” option must be set to no.

    Labels (1)
    0 Kudos