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:
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
Jasper Oosterveld is a Microsoft MVP and Modern Workplace Consultant from InSpark within the Netherlands. On a daily basis, he works with customers to implement the Modern Workplace with Microsoft 365. Jasper focuses on collaboration, communication, security, adoption and governance. Jasper loves to share is expertise and love for Microsoft products with everyone who is willing to listen.
3 Comments
Anonymous
October 3, 2013 at 12:46 pmHere’s the über formula in case of 3 fields for first, middle and last name:
=CONCATENATE(PROPER(TRIM(FirstName));IF(TRIM(MiddleName)<>“”;” “&LOWER(TRIM(MiddleName))&” “;” “);PROPER(TRIM(LastName)))
Jasper Oosterveld
October 4, 2013 at 7:20 amThanks 🙂
Charles
January 1, 2020 at 2:49 pmHi man, I am really enjoying writings on your blog. They are organized well, easy to read and memorize, in spite of English being my 2nd language. All the best.