Home › MID

MID in every language

TextLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishMIDMID(text, start_num, num_chars)——
GermanTEILTEIL(Text; Erstes_Zeichen; Anzahl_Zeichen)TEILTEIL
FrenchSTXTSTXT(texte; no_départ; no_car)STXTSTXT
SpanishEXTRAEEXTRAE(texto; posición_inicial; núm_de_caracteres)EXTRAEEXTRAE
Portuguese (Brazil)EXT.TEXTOEXT.TEXTO(texto; núm_inicial; núm_caract)EXT.TEXTOEXT.TEXTO
DutchDEELDEEL(tekst; begin_getal; aantal-tekens)DEELDEEL
ItalianSTRINGA.ESTRAISTRINGA.ESTRAI(testo; inizio; num_caratt)STRINGA.ESTRAISTRINGA.ESTRAI

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 MID