Watch the demo 

Merging and combining are terms that have similar meanings, but in Excel, they are two different things. For example, if you have several columns of information over which you'd like to spread one title, you'd merge cells to get that effect. If you have information such as first and last names in separate columns, you'd combine the cell contents to show the names together in one column.

Watch this demo to see the two different techniques. You'll also see how to find merged cells and unmerge them, and you'll get special tips that address common questions about merging.

How to do it (text version):

• Merge, unmerge, combine, and split in Excel

Online training:

• Lesson: Use Excel formulas to count letters, combine text, and compare text

 Problems watching the video? Try our troubleshooting tips.