/tips http://www.goshen.edu/its/Welcome/What_s_New en-us Sun, 22 Nov 2009 07:18:05 GMT Caravel CMS RSS App Combine Column Data http://www.goshen.edu/its/Welcome/What_s_New:=combinecolumndata.html@CB2

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)





Wed, 3 May 2006 15:41:56 GMT