Joins two or more text strings into one string.
Sintaxe
CONCATENATE(text1, [text2], …)Argumentos
text1obrigatório
The first text item to join.
text2opcional
Additional text items to join, up to 255 items.
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")→Hello WorldCombines three separate strings including a space character.
Select the target cell
Click on the cell where you want the combined text to appear.
Enter the formula
Type =CONCATENATE( followed by the cell references or text strings separated by commas.
No, it simply joins the characters exactly as they are provided.