SharePoint – Combine first and last name with a calculated column

2013-09-25

I created a SharePoint list for a customer to enter the staff details of a marketing department. The owner of the site wanted to add the first and last name. I thought it would be easy to automatically fill a column with the full name, based at first and last name. This is actually really easy! Just create a new calculated column and use one of the following formulas:

Carlos	Carvallo	=[Column1]&[Column2]	Combines the two strings (CarlosCarvallo)
Carlos	Carvallo	=[Column1]&” “&[Column2]	Combines the two strings, separated by a space (Carlos Carvallo)
Carlos	Carvallo	=[Column2]&”, “&[Column1]	Combines the two strings, separated by a comma and a space (Carvallo, Carlos)
Carlos	Carvallo	=CONCATENATE[Column2], “,”, [Column1])	Combines the two strings, separated by a comma (Carvallo,Carlos)

Source
http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx

Share0

Tweet0

About the author

Jasper Oosterveld

My name is Jasper Oosterveld and I live in Amsterdam with my wife Katie, our daughter Flora and our dog Millie. I have been working with SharePoint since 2007 as a SharePoint Consultant. In my role as SharePoint Consultant I support customers with the process of implementing SharePoint. Collaborating in the SharePoint and Office 365 community is a passion of mine. I speak regularly at SharePoint and Office 365 community events such as DIWUG, Office 365 User Group, SharePoint and Office 365 Saturday, SharePoint Connections and the European SharePoint Conference.