Concatenate Formula

Excel 2010 Concatenate Formula

Theory
=CONCATENATE(Field 1," ",Field 2)
Example:
=CONCATENATE(B2," ",C2)
The concatenate formula is ideal for merging two or more fields together. The concatenate formula is also ideal for creating unique identifier fields or unique ID columns without creating a completely new column for inputting. For example, merging or Concatenate("Full Name" + "D.O.B" + "Post Code") of a customer can be used as an ID column. Though the data will have to be complete and kept clean.