combining 2 pieces of text from 2 columns
 

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.


--
alexy
------------------------------------------------------------------------
alexy's Profile: http://www.excelforum.com/member.php...o&userid=25905
View this thread: http://www.excelforum.com/showthread...hreadid=467782

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

"alexy" wrote:


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.


--
alexy
------------------------------------------------------------------------
alexy's Profile: http://www.excelforum.com/member.php...o&userid=25905
View this thread: http://www.excelforum.com/showthread...hreadid=467782

Good morning Alexy

Either of these two will do the trick:

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=467782

=A2&" "&B2

--
HTH

Bob Phillips

"alexy" wrote in
message ...

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.


--
alexy
------------------------------------------------------------------------
alexy's Profile:
http://www.excelforum.com/member.php...o&userid=25905
View this thread: http://www.excelforum.com/showthread...hreadid=467782