How to merge columns in Microsoft Excel?

Guide to merge columns in Microsoft Excel.

This month's most popular software guide you should know - How to move photos from my iPhone to my computer



Step 1 -In your worksheet select the cells you want to combine and click the Merge Cells Wizard icon.



Step 2 -In the Merge Cells Wizard dialog box, please set the parameters you need:

• "Merge selected cells" field: row by row
• "Separate values with" field: press Alt+Enter
• "Place the results to" field: select left cell
• Check the "Clear the content of selected cells" checkbox
• Click the "Merge" button.

Step 3 - That's all, you have the addresses in one cell separated by line breaks.

---

Merge Cells Wizard for Microsoft Excel

Merge Cells Wizard is an add-in for Microsoft Excel that merges, or joins, cells values. Use the Merge Cells Wizard every time you need to place data from several cells to one cell or when you need to merge cells retaining their values. With Merge Cells Wizard you can merge data from several Microsoft Excel cells into one cell using any separator you like (including the carriage return / line break). Free to try it.