Demo: Combine the contents of multiple cells into 1 cell

Combining contents of cells in worksheet 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):

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language