TRIM

Formula Explanation

Removes leading and trailing spaces from a string.

Formula Syntax

Enter in the result column: trim("string to be processed")

• Parameters can also be replaced with data column codes, which are the codes at the top of each column in the table, e.g., AA1.

Usage Example

Remove leading and trailing spaces from column ET2 and write the result in column ET3.

ET3 = trim(ET2)

✉️ Ask TableDI