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
Wednesday, July 01, 2009

Zimbra Email Migration

ITS will be migrating the existing email server over to a new email server. The migration process will begin at 11:00 p.m., Thursday, July 2nd and will continue throughout the weekend. For information about the migration and how it will effect you, please visit http://www.goshen.edu/zimbra

 

 
Login Button