In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to combine. This is where your combined data will be displayed.

Step 2: If you simply click on the Merge and Center button, then the "Q1 Sales" will be spread across the three cells and centered. Note that any data in the cells to the right will be overwritten ...

To illustrate, let’s combine the address elements into a single cell. 1. Select the address columns, City, State and ZIP Code. To create a multi-column selection, click the header of the first ...