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.