Demo: Combine the contents of multiple cells into 1 cell

Combining contents of cells in worksheet Play Demo Demo button

Or Down arrow download the demo.

(You may experience a delay while the demo is loading.)

Do you ever want to combine the contents of several cells into one cell? Say you have a worksheet of employee names, with first and last names in separate columns, but you want both names in the same column. Excel offers two different formula methods for doing just that. Watch the demo and see how to use a fast formula to save yourself lots of time and typing.

How to do it (text version):

Assistance Problems watching the video? Try our troubleshooting tips.

 
 
Applies to:
Excel 2007