Home › LEFT

LEFT in every language

TextLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishLEFTLEFT(text, [num_chars])——
GermanLINKSLINKS(Text; [Anzahl_Zeichen])LINKSLINKS
FrenchGAUCHEGAUCHE(texte; [no_car])GAUCHEGAUCHE
SpanishIZQUIERDAIZQUIERDA(texto; [Núm_de_caracteres])IZQUIERDAIZQUIERDA
Portuguese (Brazil)ESQUERDAESQUERDA(texto; [núm_caract])ESQUERDAESQUERDA
DutchLINKSLINKS(tekst; [aantal-tekens])LINKSLINKS
ItalianSINISTRASINISTRA(testo; [num_caratt])SINISTRASINISTRA

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with LEFT