Home › TEXT

TEXT in every language

TextLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishTEXTTEXT(value, format_text)——
GermanTEXTTEXT(Wert; Textformat)TEXTTEXT
FrenchTEXTETEXTE(valeur; format_texte)TEXTETEXTE
SpanishTEXTOTEXTO(valor; formato)TEXTOTEXTO
Portuguese (Brazil)TEXTOTEXTO(valor; formato_texto)TEXTOTEXTO
DutchTEKSTTEKST(waarde; notatie_tekst)TEKSTTEKST
ItalianTESTOTESTO(val; formato)TESTOTESTO

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 TEXT