Demo: Combine the contents of multiple cells into 1 cell

Play Demo 

Or 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):

• Combine the contents of multiple cells
• Combine first and last names
• Combine text and numbers
• Combine two or more columns by using a function
• CONCATENATE function

Problems watching the video? Try our troubleshooting tips.