Left

Returns a substring that begins at the start of a given string column values. Category: text Syntax:

Left([string_column], number)

Returns: StringColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`string_column`	`column`	✓ Yes	The string column from which a left substring will be returned.
`number`	`number`	✓ Yes	The desired length of the returned substring. A negative number removes characters from the end.

Allowed Column Types: STRING, TEXT

Left([Address], 5)

Returns first 5 characters of each address.

Last modified on March 13, 2026