How to Merge Two Cells in Microsoft Excel

How to Merge Two Cells in Microsoft Excel

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.

Video transcript:

  1. How to Merge Two Cells in Microsoft Excel
  2. 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.
  3. 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
  4. If you want the spacing between the data, the function in that case is =A2&” “&B2
  5. Here we can write anything instead of a space, for example a hyphen
  6. To apply this function to multiple cells, select the cell and drag to all the cells you want to merge

Rate:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *