TRIM (PQL - xl)
This function removes extra spaces from a string and leaves single spaces between words
- Library: PQL \ Spreadsheet \ Text
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
TRIM(text)
Function Arguments
Name | Description | Type | Optional |
text | The argument specifies the string containing the spaces you want to remove | String |
|
Comments
This function is the same as the Microsoft Excel 'TRIM' function - using the same inputs, logic and outputs.