Combine first and last name fields into a Full Name field

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a First name field and a Last name field. How do I combine first and last name fields into a Full Name field?

Photo of Michael Williams

Michael Williams

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Brendan

Brendan

  • 40 Points
Hi Michael,

Try creating a Formula Text field with the following formula:

[First Name Field] & " " & [Last Name Field]

I hope this helps!  Give this a try and let me know how it goes.
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
Using "List" may be more desirable if any of the name fields are blank:



List(" ",[First Name Field],[Last Name Field])



The " " is the separator.  The advantage is if the first name field is blank then the space will be ignored so you don't have a leading space on a last name unless there is actually a first name present