• CMIT on twitter

  • Advertisements

Join First and Last Names in a Single Cell

Unless you’re a power user or a statistician, chances are you often use Excel to manage text lists instead of numerical data. For example, you might use Excel as your source file for a mail merge.
Let’s imagine that somewhere along the way you separated out first names from last names, and now you want to join them back together in a single column. Like this:

Instead of going through your list and retyping all those names, you can tell Excel to put the first name, a space, and the last name in a single cell. The formula is pretty simple:
=A3&” “&B3

The ampersand tells Excel to join one value to another, while the quotation marks tell Excel to insert a specific character (or a space, in this case). So the formula above says, in effect, “Join the first name to a space, and then join the space to the last name.”

To repeat the formula, just grab the lower right hand corner of the cell and drag down.


One Response

  1. Hi,
    great site! very interesting!
    Bye, Andrea from italy!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: