/
LEFT

LEFT

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

LEFT(<string>;<number>)

Description

Returns the leftmost characters from a text value.

Examples

Column1NumberLEFT returns
Hello Hannes3Hel
Datameer5Datam
Good morning2Go

Related content

REPLACE
REPLACE
Datameer X v11
Read with this
LEFT
LEFT
Datameer X v10
More like this
REGEXTRACT
REGEXTRACT
Datameer X v11
Read with this
RIGHT
RIGHT
Datameer X v11
More like this
REPLACEALL
REPLACEALL
Datameer X v11
Read with this
RIGHT
RIGHT
Datameer X v10
More like this