Concatenate multiple columns in List using Calculated Column in SharePoint 2013/2016/Online

This SharePoint tutorial, we will discuss how to concatenate two list columns in SharePoint 2013 using SharePoint calculated column.

Here in this example, I have a SharePoint list which has two columns name as column1 and column2. And we are concatenating these two columns and displaying the result in a 3rd column using the calculated column in SharePoint 2013/2016/Online.

Here first two columns in the SharePoint list and then create another column of type calculated column. And add the formula like below:


You can check out the formula how it looks like:

Concatenate multiple columns in SharePoint
Concatenate multiple columns in SharePoint

Now if you add an item to the SharePoint list then the concatenate value will appear in the 3rd column like below:

Concatenate multiple columns in SharePoint 2013
Concatenate multiple columns in SharePoint 2013

You may like following SharePoint calculated column tutorials:

Hope this SharePoint tutorial helps to learn how to use CONCATENATE function in SharePoint list calculated column to concatenate multiple columns in SharePoint 2013/2016/Online List.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.