Data contained in multiple Microsoft Excel cells often need to be merged and displayed in a single cell. There are several ways to do this, but the best way is to use a function. Other methods may be a bit simpler, but with the function, you will have the most flexibility, so we suggest you do it this way.
Check out our video tutorial where we show you how to merge two cells in Microsoft Excel using Windows 10.
- How to Merge Two Cells in Microsoft Excel
- There are several ways to merge cells in Excel. Probably the best way is with a function. First, select the cell that will contain the data from the cells we are merging.
- In the function field, type =, then the first cell you want to merge, then the & sign, and then the second cell you merge. In our case the formula is =A2&B2
- If you want the spacing between the data, the function in that case is =A2&” “&B2
- Here we can write anything instead of a space, for example a hyphen
- To apply this function to multiple cells, select the cell and drag to all the cells you want to merge