Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining adjacent columns | Excel Discussion (Misc queries) | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
How to convert columns of data to one column of text | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions |