How to Merge Two Cells in Google Sheets

How to Merge Two Cells in Google Sheets

If you have data that are in different cells, and you want to have them all in one, Google Sheets has a solution. You can do this in a number of ways, and while there are simpler methods, the best is by using a function. This way you will have the most flexibility, and the function itself is more than simple.

Watch our video tutorial where we show you how to merge two cells in Google Sheets, using Windows 10.

Video Transcript:

  1. How to Merge Two Cells in Google Sheets
  2. We can merge cells in Sheets in several ways. Probably the best way is with a function. First, mark the cell where the data from the cells we are merging will be in.
  3. In the function box, type the = sign, then the first cell you’re merging, then the & sign, then the second cell you’re merging. In our case the formula is =A2&B2
  4. If you want this function to be applied to all the cells in the column, click on the check mark sign
  5. If you want a space between the data of the cells you merge, the function in that case reads =A2&” “&B2. Here, instead of spaces, we can write anything.
  6. To apply this function to multiple cells, highlight the cell and drag to all the cells you want to merge. In our case it will change the function that is already written.


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

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 *