Combine two cells

[mate]

I have a "first name" cell and a "last name" cell. How
would I create another column that combines the first and
last names into one. i.e.

First Name Last Name Name
Pete Smith Pete Smith

 

[Andy B]

Hi

You could use either
=A1 & " " & B1
or
=CONCATENATE(A1," ",B1)

 

[Guest]

There are two ways to go about this, possibly the easiest is the notation of

=A2&" "&B2

This will take the value from the first cell (feel free to replace the A2) then add in the character(s) inside the quotes, in this case, a single space, then add the value of the second cell.

Another way to do this is to use the CONCATENATE function. The &'s are shorthand notation for the CONCATENATE fuction.

So, another notation would be:

=CONCATENATE(A2, " ", B2)

Hope this was helpful.

 

[mate]

Thanks all for your help!