Skip to main content

Combine name & surname

  • June 21, 2017
  • 5 replies
  • 167 views

Help! How do I combine first name (column 1) and last names (column 2) in a 3rd column?

5 replies

  • Known Participant
  • June 21, 2017

hi,

you can creat a formula type field, and then use one of the following formulas:

CONCATENATE(NAME, " ", SURNAME) -> Output will be “Klaus Becker”

CONCATENATE(SURNAME, ", " , NAME) -> Output will be “Becker, Klaus”


  • Author
  • New Participant
  • June 21, 2017

hi,

you can creat a formula type field, and then use one of the following formulas:

CONCATENATE(NAME, " ", SURNAME) -> Output will be “Klaus Becker”

CONCATENATE(SURNAME, ", " , NAME) -> Output will be “Becker, Klaus”


Thanks Klaus, I’ll try that. Victor


  • Author
  • New Participant
  • June 21, 2017

Does not work as formulated. Help!


  • Author
  • New Participant
  • June 21, 2017

My sincere apology and thanks. It does work. I at first included ‘->’; you can tell - i am a newbie.
Thanks & God Bless! Victor


  • Known Participant
  • July 6, 2017

My sincere apology and thanks. It does work. I at first included ‘->’; you can tell - i am a newbie.
Thanks & God Bless! Victor


you’re welcome, sorry, I don’t visit this too often.