Combine Data From Columns in Excel

Say you have two columns in Excel, one containing first names and one containing last names and you want to combine each first and last name into a cell.  Below are formulas for two different ways of combining the data.

 

A

B

1

First Name

Last Name

2

Nancy

Davolio

3

Andrew

Fuller

 

Formula

Description (Result)

 

=A2&" "&B2

Combines the names above, separated by a space (Nancy Davolio)

 

=B3&", "&A3

Combines the names above, separated by a comma (Fuller, Andrew)





News Archive
Friday, August 25, 2006

Microsoft Logo Current students, faculty and staff can purchase Microsoft software at a significantly reduced price, saving over 85% off retail!  Don't wait any longer to take advantage of this fabulous savings.  Click here for more information and to place your order through our secure Goshen College Software Center, powered by E-Academy, our online partner for Microsoft products.
Login Button