TROY - IT - Merge the Contents of Multiple Cells into One Cell (Microsoft Excel)

Information Technology
Merge the Contents of Multiple Cells into One Cell (Microsoft Excel)

Use a formula with the ampersand (&) operator or the CONCATENATE function to combine text from multiple cells into one cell, as presented in the following example worksheet.

A	B
First Name	Last Name
Nancy	Davolio
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)
=CONCATENATE(A2," ",B2)	Combines the names above, separated by a space (Nancy Davolio)

Note

The formula inserts a space between the first and last names by using a space enclosed within quotation marks. Use quotation marks to include any literal text—text that does not change—in the result.