Formula to merge First and Last name

Ask the Community Formulas
#1

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

Like I want full name in third column

Thanks in advance for this awesome community!!

#2

It’s simple. Use the CONCAT formula function.

CONCAT(NAME, " ", SURNAME)

Or you can use the & operator in your formula to do it. Say {NAME} & {SURNAME}