SharePoint Calculated Column Concatenate Function

In this SharePoint tutorial, I will explain what is concatenate function in a SharePoint Online calculated column. We will see below examples related to “SharePoint calculated column concatenate function“.

• How to use concatenate function in a SharePoint list calculated column to combine two strings separated by a space.
• How to combine two strings of a SharePoint-calculated column separated by a comma (,) using concatenate condition.
• How to concatenate a Title and Date column in the SharePoint list calculated column.

SharePoint Concatenate function joins several text strings into one text string. The text items can be text strings, Numbers, Date column values, or column references.

SharePoint Calculated Column Concatenate Function

In this section, I will explain an example of concatenate function that combines two text strings separated by a space in SharePoint.

SharePoint Concatenate function joins several text strings into one text string. The text items can be text strings, Numbers, Date column values, or column references.

We can also use a “&” operator to join text items instead of CONCATENATE function.

Note:

We can add up to 30 text items inside a single Concatenate()function of a SharePoint Online list calculated column.

I have a list named ‘Employee Details’ which has two columns:

1. Employee First Name – Single line of Text
2. Employee Last Name – Single line of Text

Based on both columns, I will create a SharePoint calculated column (Employee Full Name) using Concatenate Function as shown below:

• Open a SharePoint list, click the + Add column, select See all column types, and click Next.

• On Create column page, provide a name and choose the data type as calculated (calculation based on other columns). 

• In a formula box, I have applied the below-given formula to concatenate two strings separated by a space.
• Then, click on the OK button.

=CONCATENATE ([Employee First Name]," ", [Employee Last Name])

• Then, a SharePoint list calculated column will appear, as shown below screenshot:

This is how to use concatenate conditions in a calculated SharePoint list column to combine two text strings separated by a space.

SharePoint Calculated Column Concatenate Two Strings Separated by a Comma

Using concatenate condition, I will explain how to combine two strings of a SharePoint Online list calculated column separated by a comma (,).

• Open a SharePoint Online list and create a calculated column.
• On Create column page, enter a name in the Column name box and choose a data type as calculated (calculation based on other columns). 

• Then, I applied the below-given formula in a formula box and Click Ok.
  • Current Address – Single line of Text
  • Permanent Address – Single line of Text

=CONCATENATE([Current Address],","," ",[Permanent Address])

• After that, a calculated column using concatenate function can be created in a SharePoint list.

This is how to use a concatenate function in a calculated column of a SharePoint online list to combine two strings separated by a comma.

SharePoint Calculated Column Concatenate Date and Text

Likewise, I will tell you how to concatenate date and text in a SharePoint Online list calculated column.

I have a SharePoint list containing a Date and Time and a Single line of Text data type. Based on that, I have taken a calculated column to concatenate Text and Date. But it is not showing the date format in a SharePoint list calculated column as shown below:

Now, I will show you how to concatenate the date and text in a SharePoint list calculated column showing a date format.

• Open a SharePoint list and create a calculated column.
• On a Create column page, Provide a name for a column and choose the data type as Calculated (calculation based on other columns).

• In the formula box, I applied the below-given formula:
  • Title – Renamed to Product Name
  • Delivery Date – Date and Time column

=CONCATENATE(Title,," - ",TEXT([ Delivery Date],"mm/dd/yyyy"))

• The data type returned from this formula is: Choose the data type as Date and Time.
• Then, click on the OK button.

• Then a calculated column will appear in a SharePoint Online list as shown below:

This is how to concatenate date and text in a SharePoint Online list calculated column.

Conclusion

Through this SharePoint Online tutorial, I have explained some examples based on concatenate function in a calculated column of a SharePoint list.

And I have covered the below topics such as :

• SharePoint Online list calculated column to combine two strings separated by a space.
• SharePoint Online list calculated column to combine two strings separated by a comma.
• Sharepoint Online list calculated column concatenate date and text

You may also like:

• SharePoint Calculated Column Convert Text to Number
• SharePoint Calculated Column Current Date
• SharePoint Calculated Column Remove Comma from Number