Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Combine name & surname

Topic Labels: Formulas
8734 5
Showing results for 
Search instead for 
Did you mean: 

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

5 Replies 5


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

Does not work as formulated. Help!

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.