Combine 2 columns into 1 string

This question seem to be so basic but for some reason I can’t figure out how to do it.

I got 3 columns

I got first name in column1 and second name in column2 then I need to merge the two in column3, but for some reason I can’t figure out how to do this?

The Concatenate formula (https://coda.io/formulas#Concatenate) is probably what you need. Example below:

In the First column, I input first names.

In the Last column, I input last names.

In the full column, I put in the Concatenate formula. Concatenate takes items and combines them together. In this case, I combined the name in the First column, a space " ", and the name in the Last column.

Hope this helps.

3 Likes

Thank you just was I was looking for