Join two columns

Kris Peeters

I have a column for first name and one for last name that I would like to join together in a column called combined name.

This is what I tried and it doesn't work: =JOIN([First Name]@row, [Last Name]@row])

kathleen.c.carriere

Hey Kris!

I think this one can be a simple =[First Name]@row + " " + [Last Name]@row

Kathleen

Mark Chamberlain

Or you can get Last, First by using =[Last Name]@row + ", " + [First Name]@row .

I like to use this with forms to allow users to enter data in a linear form, but I get a consistent name column for all of my data.