Combine 2 cells into 1

G

Guest

hi,
assuming first name in in column a and last name is in
column b
in a helper column enter the following formula:
=concatenate(A2," ",B2)
the space between the double quotes will put a space
between the names. If you need a comma, the comma between
the double quotes.
copy the formual and copy down.
 
Top