concat
Learn how to use the concat function in Notion formulas.
The concat() function concatenates (aka combines) its arguments. It accepts one or more string arguments, and outputs a single combined string.
1
concat(string)
2
concat(string, string)
3
concat(string, string, ...)
concat() can accept any number of arguments.
Good to know: You can also concatenate strings with the add (+) operator.

1
concat("Roronoa ","Zoro") // Output: Roronoa Zoro
2
โ€‹
3
"Roronoa " + "Zoro" // Output: Roronoa Zoro
4
โ€‹
5
concat("Chopper") // Output: Chopper (this is pointless, but it works)
6
โ€‹
7
concat("Monkey", " D.", "Luffy", " will ", "be", " King of the Pirates")
8
// Output: Monkey D. Luffy will be King of the Pirates
9
โ€‹
10
// use "\n" to create line breaks
11
concat("Luffy \n", "Zoro \n", "Sanji \n", "Nami \n")
12
// Output:
13
// Luffy
14
// Zoro
15
// Sanji
16
// Nami
You can use conversion functions like format or formatDate to convert other data types into strings before concatenating them:
1
concat("Today is ", formatDate(now(), "MMMM DD, YYYY"))
2
// Output: Today is June 17, 2022 (this will change with the value of now())

This example database collects several different pieces of customer information, including first name, last name, phone number, and location. The Info formula neatly formats all of this information into a single cell.
To display phone numbers in a more consistent manner, there is a helper property - Ph Format - which formats the data from the Phone property. Info then pulls from Ph Format rather than Phone directly.

concat
College Info Geek on Notion

1
// Compressed
2
concat("๐Ÿง‘ ", prop("First Name"), " ", prop("Last Name"), "\n๐Ÿ“ ", prop("Location"), "\nโ˜Ž๏ธ ", prop("Ph Format"))
3
โ€‹
4
// Expanded
5
concat(
6
"๐Ÿง‘ ",
7
prop("First Name"),
8
" ",
9
prop("Last Name"),
10
"\n๐Ÿ“ ",
11
prop("Location"),
12
"\nโ˜Ž๏ธ ",
13
prop("Ph Format")
14
)
Here, we simply use concat() with multiple arguments to combine all of our properties. We also pass some useful formatting strings as arguments, such as "๐Ÿง‘ " and "\n๐Ÿ“ ". The \n characters create new lines.

1
// Compressed
2
"(" + slice(replaceAll(prop("Phone"), "[() .-]", ""), 0, 3) + ") " + slice(replaceAll(prop("Phone"), "[() .-]", ""), 3, 6) + "-" + slice(replaceAll(prop("Phone"), "[() .-]", ""), 6, 10)
3
โ€‹
4
// Expanded
5
"(" +
6
slice(
7
replaceAll(
8
prop("Phone"), "[() .-]", ""
9
), 0, 3
10
) +
11
") " +
12
slice(
13
replaceAll(
14
prop("Phone"), "[() .-]", ""
15
), 3, 6
16
) +
17
"-" +
18
slice(
19
replaceAll(
20
prop("Phone"), "[() .-]", ""
21
), 6, 10
22
)
The Ph Format formula is a slightly more complex formula that uses the add (+) operator for concatenation instead of concat(). In many cases, youโ€™ll find + to be a far quicker way to combine strings.
Hereโ€™s how the formula formats the phone numbers, which are originally string values from the Phone property:
  1. 1.
    We use the slice function multiple times to chop the phone number into three discrete pieces.
    1. 1.
      For each piece, we use replaceAll and the regular expression "[() .-]" to remove any non-numeric characters. The brackets ([]) indicate that every matched instance of any character between them should be replaced.
  2. 2.
    Next, we use the + operator to concatenate these number slices with useful formatting (e.g. "(" and "-") to get our standard format: (xxx) xxx-xxxx.

โ€‹
My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.
Copy link
On this page
Example Formulas
Example Database
View and Duplicate Database
โ€œInfoโ€ Property Formula
โ€œPh Formatโ€ Property Formula