Skip to main content

Combine name & surname

  • June 21, 2017
  • 5 replies
  • 177 views
V

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

5 replies

K
  • Klaus_Becker
  • 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”

    V
    • Vic_Carvalho
    • 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

    V
    • Vic_Carvalho
    • Author
    • New Participant
    • June 21, 2017

    Does not work as formulated. Help!

    V
    • Vic_Carvalho
    • 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

    K
    • Klaus_Becker
    • 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.

    Terms & ConditionsAccessibility statement