Concatenate Columns Using Calculated Column in SharePoint 2010

In this blog, how to concatenate three columns (First Name, Last Name and Middle Name) using Calculated Column in SharePoint List has been explained.

I have created a List Employee having three columns, shown as below:



FullName is the Calculated Column, that displays the result after concatenating the above columns:
 


Add the given below formula in the calculated column.

=CONCATENATE(FirstName," ",MiddleName," ",LastName)

The List will display as shown below:

 
Ebook Download
View all
Learn
View all