| Functions in English | Functions in French | Description of Function |
|---|
| ASC | ASC | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters. |
| ARRAYTOTEXT | TABLEAU.EN.TEXTE | Returns an array of text values from any specified range (365). |
| BAHTTEXT | BAHTTEXT | Converts a number to text, using the ß (baht) currency format. |
| CHAR | CAR | Returns the character specified by the code number. |
| CLEAN | EPURAGE | Removes all nonprintable characters from text. |
| CODE | CODE | Returns a numeric code for the first character in a text string. |
| CONCAT | CONCAT | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments (2019). |
| DBCS | DBCS | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters. |
| DOLLAR | FRANC | Converts a number to text, using the $ (dollar) currency format. |
| EXACT | EXACT | Checks to see if two text values are identical. |
| FIND | TROUVE | Finds one text value within another (case-sensitive). |
| FIXED | CTXT | Formats a number as text with a fixed number of decimals. |
| Functions in English | Functions in French | Description of Function |
|---|
| LEFT | GAUCHE | Returns the leftmost characters from a text value. |
| LEN | NBCAR | Returns the number of characters in a text string. |
| LOWER | MINUSCULE | Converts text to lowercase. |
| MID | STXT | Returns a specific number of characters from a text string starting at the position you specify. |
| NUMBERVALUE | VALEURNOMBRE | Converts text to number in a locale-independent manner (2013). |
| PHONETIC | PHONETIQUE | Extracts the phonetic (furigana) characters from a text string. |
| PROPER | NOMPROPRE | Capitalizes the first letter in each word of a text value. |
| REGEXEXTRACT | REGEX.EXTRAIRE | Extracts a substring matching a regular expression pattern (365). |
| REGEXREPLACE | REGEX.REMPLACER | Replaces a substring matching a regular expression pattern with specified text (365). |
| REGEXTEST | REGEX.TEST | Checks if a string matches a regular expression pattern, returns TRUE or FALSE (365). |
| REPLACE | REMPLACER | Replaces characters within text. |
| REPT | REPT | Repeats text a given number of times. |
| RIGHT | DROITE | Returns the rightmost characters from a text value. |
| SEARCH | CHERCHE | Finds one text value within another (not case-sensitive). |
| SUBSTITUTE | SUBSTITUE | Substitutes new text for old text in a text string. |
| T | T | Converts its arguments to text. |
| TEXT | TEXTE | Formats a number and converts it to text. |
| TEXTAFTER | TEXTE.APRES | Returns text that occurs after given character or string (365). |
| TEXTBEFORE | TEXTE.AVANT | Returns text that occurs before a given character or string (365). |
| TEXTJOIN | JOINDRE.TEXTE | Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges (2016). |
| TEXTSPLIT | FRACTIONNER.TEXTE | Splits text strings by using column and row delimiters (365). |
| TRIM | SUPPRESPACE | Removes spaces from text. |
| UNICHAR | UNICAR | Returns the Unicode character that is references by the given numeric value (2013). |
| UNICODE | UNICODE | Returns the number (code point) that corresponds to the first character of the text (2013). |
| UPPER | MAJUSCULE | Converts text to uppercase. |
| VALUE | CNUM | Converts a text argument to a number. |
| VALUETOTEXT | VALEUR.EN.TEXTE | Returns text from any specified value (365). |