Google Sheets-funktion

CONCATENATE

Joins two or more text strings into one string.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

text1obligatorisktThe first text item to join.
text2valfrittAdditional text items to join, up to 255 items.

Exempel

=CONCATENATE("Hello", " ", "World")

Resultat: Hello World

Combines three separate strings including a space character.

Vanliga frågor

Is CONCATENATE case-sensitive?

No, it simply joins the characters exactly as they are provided.

Relaterade funktioner

CONCAT TEXTJOIN REPLACE