Concatenating Two Columns

  • Thread starter Thread starter Wallingford House
  • Start date Start date
W

Wallingford House

I need to concatenate an entire column of first names and a matching
column of last names into a new column of first name:" ":last name.
Can I use the "CONCATENATE" command once to accomplish this? If so,
what is the exact syntax I should use and in what cell should I put
the command?
 
Assuming your first names are in column A and last names in B, put
this in cell C1:

=A1 &" "& B1

(quicker than typing CONCATENATE).

Then you can copy this down column C for as many rows as you need. A
quick way of doing this is to select C1 and then double-click the Fill
Handle - this is the small black square in the bottom right corner of
the cursor.

Hope this helps.

Pete
 
I need to concatenate an entire column of first names and a matching
column of last names into a new column of first name:" ":last name.
Can I use the "CONCATENATE" command once to accomplish this? If so,
what is the exact syntax I should use and in what cell should I put
the command?
Click to expand...

Thank you for your prompt reply. I am using Excel 2002. I don't see a
fill handle on my cursor.
 
Hi,

First, if you really want the ":"'s you should change the formula to read
=A1&": :"&B1

The fill handle is available many versions back, it is at the bottom right
corner of the selected cell and displays as a tiny black square, when you put
your mouse over it the mouse changes to a black cross-hair. If this is still
not available choose Tools, Options, Edit and check the box that says Allow
cell drag and drop.

If you don't want to do that, just highlight the formula and all the cells
below it where you want the formula copied and press Ctrl+D.

If this helps, please click the Yes button.
 
Back
Top