Adding Name and Surname

[Jacobs556]

Hello i have two columns, in A1 Column is Names and on A2 Column is surnames, how do i add them So i get Name Surname?

I want opposite of this photo.

 

[JamesLoft]

Hello, u can use CONCATENATE formula. So in example if you want your Full name to be on A3 Column, you write formula on A3: =CONCATENATE(A1," ",A2).

 

[SQUIDD]

hi

in A2
=C2&" "&D2

dave

 

[Jacobs556]

Thank you!