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
Here’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)))
Thanks 🙂
Hi 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.