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)