Am I a member?
Browse the member listing...

02-15-10 Tip O' The Week

Excel - Combine = Concatenate

Need to combine the text of two cells into one cell in Excel, such as combining the first and last names into column C below? 

Combine First and Last Names in One Cell
In cell C1, type =A1&" "&B1. The result is "Nancy Davolio" in cell C1. The space between the quotation marks in the formula inserts a space between the two names.

To reverse the order of the names, type =B1&", "&A1. The result is "Davolio, Nancy" in cell C1. The comma and the space between the quotation marks in the formula insert a comma and a space between the names.

Note:  You can also combine text by using the CONCATENATE function: =CONCATENATE(A1," ",B1), but it's faster to just type the ampersands.
From: 
Email:  
To: 
Email:  
Subject: 
Message: