Combine two cells

  • Thread starter Thread starter mate
  • Start date Start date
M

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
 
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.
 
Back
Top