Skip to main content
CONCAT

Concatenates multiple text strings into a single string

Updated over a year ago

Description

The CONCAT() function allows you to combine multiple text strings into one, which can be useful for creating dynamic labels, combining names, or constructing sentences from text fragments.

Syntax

CONCAT(text1, text2, )

Output

text

Variables

  1. 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

CIONCAT('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.

Did this answer your question?