combining 2 pieces of text from 2 columns

A

alexy

Column A has first names, and B second names.
I want C to list the 2 names together, how do I do this?

thanks, Alex.
 
E

Ellie

Hi Alex

Assuming you have put one blank space after the first name, in column C you
can use the following:-

=CONCATENATE(A1,B1)

If you haven't, when using the formula wizard select CONCATENATE and in the
Text1 box, select the cell A1 and put one blank space after it

Hope this helps you.

Ellie
 
D

dominicb

Good morning Alexy

Either of these two will do the trick:

=CONCATENATE(A1," ",B1)
=A1&" "&B1

HTH

Dominic
 
Top