Joins two or more text strings into one string.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
CONCATENATE(text1, [text2], …)The CONCATENATE function is used to combine text from multiple cells or static strings into a single cell. While still available for backward compatibility, it is recommended to use the CONCAT or TEXTJOIN functions in newer versions of Excel.
=CONCATENATE("Hello", " ", "World")Résultat : Hello World
Combines three separate strings including a space character.
No, it simply joins the characters exactly as they are provided.