SharePoint

Combine first and last name with a calculated column

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

You Might Also Like

2 Comments

  • Reply
    Anonymous
    October 3, 2013 at 12:46 pm

    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)))

  • Reply
    Jasper Oosterveld
    October 4, 2013 at 7:20 am

    Thanks 🙂

  • Leave a Reply to Jasper Oosterveld Cancel Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.