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: