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