Demo: Combine the contents of multiple cells into 1 cell
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):
Problems watching the video? Try our troubleshooting tips.