Description | The |
Syntax | CONCAT( |
Output | text |
Variables
text1
,text2
,...
: These are the text strings you want to concatenate. You can include multiple text strings separated by commas.
Example 1
CONCAT(`Column 1`,`Column 2`,`Column 3`)
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | Hello,world! |
This | is a | test | Thisis atest |
Savant | is | amazing | Savantisamazing |
Example 2
CONCAT('How ','are ','you','?')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | How are you? |
This | is a | test | How are you? |
Savant | is | amazing | How are you? |
Example 3
CONCAT(`Column 1`,'|Column 1')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | Hello|Column 1 |
This | is a | test | This|Column 1 |
Savant | is | amazing | Savant|Column 1 |
Example 4
CONCAT(TO_TEXT(TODAY()),'_is_today.')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | 2023-10-11_is_today. |
This | is a | test | 2023-10-11_is_today. |
Savant | is | amazing | 2023-10-11_is_today. |