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

Concatenate multiple columns in SharePoint 2013

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.

SharePoint deveopment training course

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

=CONCATENATE(column1,"-",column2)

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.

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →