Text
In the following an alphabetically sorted list of all Excel functions for the category Text of the current version of Microsoft Excel as well as their translations in the selected language. Please note, that in earlier versions of Excel the translations may be different. A detailed list of the translations for each function from Microsoft Excel 2010 and above can be found in the linked article.
Translations
Product | Microsoft Excel (Office 365) |
Category | Text |
Source language | English |
Target language |
B | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BAHTTEXT | BAHTTEXT | BAHTTEKST | BAHT.TEKST | BAHTTEXT | BAHTTEKSTI | BAHTTEXT | BAHTTEXT | BAHTTEXT | BAHTSZÖVEG | BAHTTESTO | BAHTTEXT | BAHTTEKST | BAT.TEKST | BAHTTEXT | TEXTO.BAHT | БАТТЕКСТ | BAHTTEXT | TEXTOBAHT | BAHTTEXT | BAHTMETİN |
C | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHAR | ZNAK | TEGN | TEKEN | CHAR | MERKKI | CAR | ZEICHEN | CHAR | KARAKTER | CODICE.CARATT | CHAR | TEGNKODE | ZNAK | CARACT | CARÁT | СИМВОЛ | CHAR | CARACTER | TECKENKOD | DAMGA |
CLEAN | VYČISTIT | RENS | WISSEN.CONTROL | CLEAN | SIIVOA | EPURAGE | SÄUBERN | CLEAN | TISZTÍT | LIBERA | CLEAN | RENSK | OCZYŚĆ | TIRAR | LIMPARB | ПЕЧСИМВ | CLEAN | LIMPIAR | STÄDA | TEMİZ |
CODE | KÓD | KODE | CODE | CODE | KOODI | CODE | CODE | CODE | KÓD | CODICE | CODE | KODE | KOD | CÓDIGO | CÓDIGO | КОДСИМВ | CODE | CODIGO | KOD | KOD |
CONCAT | CONCAT | CONCAT | TEKST.SAMENV | CONCAT | YHDISTÄ | CONCAT | TEXTKETTE | CONCAT | FŰZ | CONCAT | CONCAT | KJED.SAMMEN | ZŁĄCZ.TEKST | CONCAT | CONCAT | СЦЕП | CONCAT | CONCAT | SAMMAN | ARALIKBİRLEŞTİR |
CONCATENATE | CONCATENATE | SAMMENKÆDNING | TEKST.SAMENVOEGEN | CONCATENATE | KETJUTA | CONCATENER | VERKETTEN | CONCATENATE | ÖSSZEFŰZ | CONCATENA | CONCATENATE | KJEDE.SAMMEN | ZŁĄCZ.TEKSTY | CONCATENAR | CONCATENAR | СЦЕПИТЬ | CONCATENATE | CONCATENAR | SAMMANFOGA | BİRLEŞTİR |
D | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DBCS | DBCS | DBCS | DBCS | DBCS | DBCS | DBCS | DBCS | DBCS | KBKK | DBCS | JIS | DBCS | DBCS | DBCS | DBCS | БДЦС | DBCS | DBCS | DBCS | DBCS |
DOLLAR | KČ | KR | EURO | CURRENCY | VALUUTTA | DEVISE | DM | CURRENCY | FORINT | VALUTA | YEN | VALUTA | KWOTA | MOEDA | MOEDA | РУБЛЬ | VALUTA | MONEDA | VALUTA | LİRA |
E | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EXACT | STEJNÉ | EKSAKT | GELIJK | EXACT | VERTAA | EXACT | IDENTISCH | EXACT | AZONOS | IDENTICO | EXACT | EKSAKT | PORÓWNAJ | EXATO | EXATO | СОВПАД | EXACT | IGUAL | EXAKT | ÖZDEŞ |
F | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FIND | NAJÍT | FIND | VIND.ALLES | FIND | ETSI | TROUVE | FINDEN | FIND | SZÖVEG.TALÁL | TROVA | FIND | FINN | ZNAJDŹ | PROCURAR | LOCALIZAR | НАЙТИ | FIND | ENCONTRAR | HITTA | BUL |
FINDB | FINDB | FINDB | VIND.ALLES.B | FINDB | ETSIB | TROUVERB | FINDENB | FINDB | SZÖVEG.TALÁL2 | TROVA.B | FINDB | FINNB | ZNAJDŹB | PROCURARB | LOCALIZARB | НАЙТИБ | FINDB | ENCONTRARB | HITTAB | BULB |
FIXED | ZAOKROUHLIT.NA.TEXT | FAST | VAST | FIXED | KIINTEÄ | CTXT | FEST | FIXED | FIX | FISSO | FIXED | FASTSATT | ZAOKR.DO.TEKST | DEF.NÚM.DEC | FIXA | ФИКСИРОВАННЫЙ | FIXED | DECIMAL | FASTTAL | SAYIDÜZENLE |
L | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LEFT | ZLEVA | VENSTRE | LINKS | LEFT | VASEN | GAUCHE | LINKS | LEFT | BAL | SINISTRA | LEFT | VENSTRE | LEWY | ESQUERDA | ESQUERDA | ЛЕВСИМВ | LEFT | IZQUIERDA | VÄNSTER | SOLDAN |
LEFTB | LEFTB | VENSTREB | LINKSB | LEFTB | VASENB | GAUCHEB | LINKSB | LEFTB | BAL2 | SINISTRAB | LEFTB | VENSTREB | LEWYB | ESQUERDAB | ESQUERDAB | ЛЕВБ | LEFTB | IZQUIERDAB | VÄNSTERB | SOLB |
LEN | DÉLKA | LÆNGDE | LENGTE | LEN | PITUUS | NBCAR | LÄNGE | LEN | HOSSZ | LUNGHEZZA | LEN | LENGDE | DŁ | NÚM.CARACT | NÚM.CARAT | ДЛСТР | LEN | LARGO | LÄNGD | UZUNLUK |
LENB | LENB | LÆNGDEB | LENGTEB | LENB | PITUUSB | LENB | LÄNGEB | LENB | HOSSZ2 | LUNGB | LENB | LENGDEB | DŁ.B | NÚM.CARACTB | NÚM.CARATB | ДЛИНБ | LENB | LARGOB | LÄNGDB | UZUNLUKB |
LOWER | MALÁ | SMÅ.BOGSTAVER | KLEINE.LETTERS | LOWER | PIENET | MINUSCULE | KLEIN | LOWER | KISBETŰ | MINUSC | LOWER | SMÅ | LITERY.MAŁE | MINÚSCULA | MINÚSCULAS | СТРОЧН | LOWER | MINUSC | GEMENER | KÜÇÜKHARF |
M | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MID | ČÁST | MIDT | DEEL | MID | POIMI.TEKSTI | STXT | TEIL | MID | KÖZÉP | STRINGA.ESTRAI | MID | DELTEKST | FRAGMENT.TEKSTU | EXT.TEXTO | SEG.TEXTO | ПСТР | MID | EXTRAE | EXTEXT | PARÇAAL |
MIDB | MIDB | MIDTB | DEELB | MIDB | POIMI.TEKSTIB | MIDB | TEILB | MIDB | KÖZÉP2 | MEDIA.B | MIDB | DELTEKSTB | FRAGMENT.TEKSTU.B | EXT.TEXTOB | SEG.TEXTOB | ПСТРБ | MIDB | EXTRAEB | EXTEXTB | ORTAB |
N | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NUMBERVALUE | NUMBERVALUE | TALVÆRDI | NUMERIEKE.WAARDE | NUMBERVALUE | NROARVO | VALEURNOMBRE | ZAHLENWERT | NUMBERVALUE | SZÁMÉRTÉK | NUMERO.VALORE | NUMBERVALUE | TALLVERDI | WARTOŚĆ.LICZBOWA | VALORNUMÉRICO | VALOR.NÚMERO | ЧЗНАЧ | NUMBERVALUE | VALOR.NUMERO | TALVÄRDE | SAYIDEĞERİ |
P | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PROPER | VELKÁ2 | STORT.FORBOGSTAV | BEGINLETTERS | PROPER | ERISNIMI | NOMPROPRE | GROSS2 | PROPER | TNÉV | MAIUSC.INIZ | PROPER | STOR.FORBOKSTAV | Z.WIELKIEJ.LITERY | PRI.MAIÚSCULA | INICIAL.MAIÚSCULA | ПРОПНАЧ | PROPER | NOMPROPIO | INITIAL | YAZIM.DÜZENİ |
R | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
REPLACE | NAHRADIT | ERSTAT | VERVANGEN | REPLACE | KORVAA | REMPLACER | ERSETZEN | REPLACE | CSERE | RIMPIAZZA | REPLACE | ERSTATT | ZASTĄP | MUDAR | SUBSTITUIR | ЗАМЕНИТЬ | REPLACE | REEMPLAZAR | ERSÄTT | DEĞİŞTİR |
REPLACEB | NAHRADITB | ERSTATB | VERVANGENB | REPLACEB | KORVAAB | REMPLACERB | ERSETZENB | REPLACEB | CSERE2 | SOSTITUISCI.B | REPLACEB | ERSTATTB | ZASTĄP.B | SUBSTITUIRB | SUBSTITUIRB | ЗАМЕНИТЬБ | REPLACEB | REEMPLAZARB | ERSÄTTB | DEĞİŞTİRB |
REPT | OPAKOVAT | GENTAG | HERHALING | REPT | TOISTA | REPT | WIEDERHOLEN | REPT | SOKSZOR | RIPETI | REPT | GJENTA | POWT | REPT | REPETIR | ПОВТОР | REPT | REPETIR | REP | YİNELE |
RIGHT | ZPRAVA | HØJRE | RECHTS | RIGHT | OIKEA | DROITE | RECHTS | RIGHT | JOBB | DESTRA | RIGHT | HØYRE | PRAWY | DIREITA | DIREITA | ПРАВСИМВ | RIGHT | DERECHA | HÖGER | SAĞDAN |
RIGHTB | RIGHTB | HØJREB | RECHTSB | RIGHTB | OIKEAB | DROITEB | RECHTSB | RIGHTB | JOBB2 | DESTRA.B | RIGHTB | HØYREB | PRAWY.B | DIREITAB | DIREITAB | ПРАВБ | RIGHTB | DERECHAB | HÖGERB | SAĞB |
S | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SEARCH | HLEDAT | SØG | VIND.SPEC | SEARCH | KÄY.LÄPI | CHERCHE | SUCHEN | SEARCH | SZÖVEG.KERES | RICERCA | SEARCH | SØK | SZUKAJ.TEKST | LOCALIZAR | PROCURAR | ПОИСК | SEARCH | HALLAR | SÖK | MBUL |
SEARCHB | SEARCHB | SØGB | VIND.SPEC.B | SEARCHB | KÄY.LÄPIB | CHERCHERB | SUCHENB | SEARCHB | SZÖVEG.KERES2 | CERCA.B | SEARCHB | SØKB | SZUKAJ.TEKST.B | LOCALIZARB | PROCURARB | ПОИСКБ | SEARCHB | HALLARB | SÖKB | ARAB |
SUBSTITUTE | DOSADIT | UDSKIFT | SUBSTITUEREN | SUBSTITUTE | VAIHDA | SUBSTITUE | WECHSELN | SUBSTITUTE | HELYETTE | SOSTITUISCI | SUBSTITUTE | BYTT.UT | PODSTAW | SUBSTITUIR | SUBST | ПОДСТАВИТЬ | SUBSTITUTE | SUSTITUIR | BYT.UT | YERİNEKOY |
T | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | Т | T | T | T | M |
TEXT | HODNOTA.NA.TEXT | TEKST | TEKST | TEXT | TEKSTI | TEXTE | TEXT | TEXT | SZÖVEG | TESTO | TEXT | TEKST | TEKST | TEXTO | TEXTO | ТЕКСТ | TEXT | TEXTO | TEXT | METNEÇEVİR |
TEXTJOIN | TEXTJOIN | TEKST.KOMBINER | TEKST.COMBINEREN | TEXTJOIN | TEKSTI.YHDISTÄ | JOINDRE.TEXTE | TEXTVERKETTEN | TEXTJOIN | SZÖVEGÖSSZEFŰZÉS | TESTO.UNISCI | TEXTJOIN | TEKST.KOMBINER | POŁĄCZ.TEKSTY | UNIRTEXTO | UNIRTEXTO | ОБЪЕДИНИТЬ | TEXTJOIN | UNIRCADENAS | TEXTJOIN | METİNBİRLEŞTİR |
TRIM | PROČISTIT | FJERN.OVERFLØDIGE.BLANKE | SPATIES.WISSEN | TRIM | POISTA.VÄLIT | SUPPRESPACE | GLÄTTEN | TRIM | KIMETSZ | ANNULLA.SPAZI | TRIM | TRIMME | USUŃ.ZBĘDNE.ODSTĘPY | ARRUMAR | COMPACTAR | СЖПРОБЕЛЫ | TRIM | ESPACIOS | RENSA | KIRP |
U | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
UNICHAR | UNICHAR | UNICHAR | UNITEKEN | UNICHAR | UNICODEMERKKI | UNICAR | UNIZEICHEN | UNICHAR | UNIKARAKTER | CARATT.UNI | UNICHAR | UNICODETEGN | ZNAK.UNICODE | CARACTUNICODE | UNICARÁT | ЮНИСИМВ | UNICHAR | UNICAR | UNITECKENKOD | UNICODEKARAKTERİ |
UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE | UNICODE |
UPPER | VELKÁ | STORE.BOGSTAVER | HOOFDLETTERS | UPPER | ISOT | MAJUSCULE | GROSS | UPPER | NAGYBETŰS | MAIUSC | UPPER | STORE | LITERY.WIELKIE | MAIÚSCULA | MAIÚSCULAS | ПРОПИСН | UPPER | MAYUSC | VERSALER | BÜYÜKHARF |
V | Czech | Danish | Dutch | Estonian | Finnish | French | German | Greek | Hungarian | Italian | Japanese | Norwegian | Polish | Portuguese, Brazil | Portuguese, Portugal | Russian | Slovenian | Spanish | Swedish | Turkish |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VALUE | HODNOTA | VÆRDI | WAARDE | VALUE | ARVO | CNUM | WERT | VALUE | ÉRTÉK | VALORE | VALUE | VERDI | WARTOŚĆ | VALOR | VALOR | ЗНАЧЕН | VALUE | VALOR | TEXTNUM | SAYIYAÇEVİR |