Fonctions Texte

[ ] indicates optional parameters

CAR(nombre)
CHERCHE(texte_cherché; texte; [no_départ])
CNUM(texte)
CODE(texte)
CONCATENER(texte1; [texte2; ...])
CTXT(nombre; [décimales]; [no_séparateur])
DROITE(texte; [no_car])
EPURAGE(texte)
EXACT(texte1; texte2)
FRANC(nombre; [décimales])
GAUCHE(texte; [no_car])
MAJUSCULE(texte)
MINUSCULE(texte)
NBCAR(texte)
NOMPROPRE(texte)
REMPLACER(ancien_texte; no_départ; no_car; nouveau_texte)
REPT(texte; no_fois)
STXT(texte; no_départ; no_car)
SUBSTITUE(texte; ancien_texte; nouveau_texte; [no_position])
SUPPRESPACE(texte)
T(valeur)
TEXTE(valeur; format_texte)
TROUVE(texte_cherché; texte; [no_départ])


Fonctions Texte

CAR(nombre)

Returns the character corresponding to the specified position in the character set.

nombreThe number of the character that you want.


CHERCHE(texte_cherché; texte; [no_départ])

Returns a number corresponding to the position of one text string within another (not case-sensitive).

texte_cherchéThe text you want to find.
texteThe text to be searched.
no_départThe position at which to start searching. If this parameter is omitted it defaults to 1.


CNUM(texte)

Returns a number which corresponds to the value in the input string. You should not need to use this function, as values are automatically converted from text to numeric when required in formulas.

texteThe string that you want to convert to a number.


CODE(texte)

Returns the position in the character set of the first character in the string.

texteThe character of which you want the character code.


CONCATENER(texte1; [texte2; ...])

Returns a string consisting of the input strings concatenated together.

texte1; ...The strings that you want to concatenate.


CTXT(nombre; [décimales]; [no_séparateur])

Returns a string consisting of the input number rounded to the specified number of decimal places.

nombreThe number that you want to format.
décimalesThe number of decimal places required. If this parameter is omitted it defaults to 2.
no_séparateurSpecifies whether to suppress the thousands separator in the formatted number. The possible values are:
FAUXThe thousands separator is used.
VRAIThe thousands separator is not used.
If this parameter is omitted it defaults to FAUX.


DROITE(texte; [no_car])

Returns a string consisting of the specified number of characters from the end of the input string.

texteThe string of which you want the end.
no_carThe number of characters to extract from the string. If this parameter is omitted it defaults to 1.


EPURAGE(texte)

Returns a string corresponding to the input string with any unprintable characters removed.

texteThe text from which you want to remove unprintable characters.


EXACT(texte1; texte2)

Returns VRAI if the input strings are exactly the same, otherwise FAUX.

texte1The first string to be compared.
texte2The second string to be compared.


FRANC(nombre; [décimales])

Returns a string consisting of the input number rounded to the specified number of decimal places and converted to currency format.

nombreThe amount that you want to format.
décimalesThe number of decimal places required. If this parameter is omitted it defaults to 2.


GAUCHE(texte; [no_car])

Returns a string consisting of the specified number of characters from the beginning of the input string.

texteThe string of which you want the beginning.
no_carThe number of characters to extract from the string. If this parameter is omitted it defaults to 1.


MAJUSCULE(texte)

Returns a string which is the input string with all of the characters converted to upper case.

texteThe string that you want to convert.


MINUSCULE(texte)

Returns a string which is the input string with all of the characters converted to lower case.

texteThe string you want to convert.


NBCAR(texte)

Returns the length of the input string.

texteThe string of which you want the length.


NOMPROPRE(texte)

Returns a string which is the input string with the first letter of each word converted to upper case and all of the other characters converted to lower case.

texteThe string you want to convert.


REMPLACER(ancien_texte; no_départ; no_car; nouveau_texte)

Returns a string which is the input string with a specified portion replaced.

ancien_texteThe string you want to convert.
no_départThe starting position of the text to be removed.
no_carThe number of characters to be removed.
nouveau_texteThe text to be inserted into the string.


REPT(texte; no_fois)

Returns a string which is the input string repeated a specified number of times.

texteThe string you want to repeat.
no_foisThe number of times to repeat the string.


STXT(texte; no_départ; no_car)

Returns a string consisting of the specified number of characters from the specified position of the input string.

texteThe string of which you want the extract.
no_départThe starting position of characters to extract from the string.
no_carThe number of characters to extract from the string.


SUBSTITUE(texte; ancien_texte; nouveau_texte; [no_position])

Returns a string which is the input string with specified text replaced.

texteThe string you want to convert.
ancien_texteThe string to be removed from the original text.
nouveau_texteThe string to be inserted in the original text.
no_positionSpecifies which occurrence of old_text is to be replaced. If this parameter is omitted then all occurrences are replaced.


SUPPRESPACE(texte)

Returns a string consisting of the input string with any extra spaces removed.

texteThe string that you want to format.


T(valeur)

Returns a string which is the input value if it is text, otherwise an empty string.

valeurThe value you want if it is a string.


TEXTE(valeur; format_texte)

Returns a string consisting of the input number formatted using the specified format string.

valeurThe number that you want to format.
format_texteThe format string to use.


TROUVE(texte_cherché; texte; [no_départ])

Returns a number corresponding to the position of one text string within another (case-sensitive).

texte_cherchéThe text you want to find.
texteThe text to be searched.
no_départThe position at which to start searching. If this parameter is omitted it defaults to 1.