Buzz
Google Sheets is a free application similar to Microsoft Excel, available for both web and mobile platforms. While Google Sheets may not have all the features of Excel, it performs excellently on mobile devices. Google Sheets can be used offline or synchronized with Google Drive for easy sharing across different devices. This article will show you how to merge cells in Google Sheets on the mobile version.
HOW TO MERGE CELLS IN GOOGLE SHEETS ON THE MOBILE VERSION
Instructions for Single-Text Cells:
Step 1: Select the cells you wish to merge. You can do this by clicking on a cell and dragging the blue dot at the corner until all desired cells are selected.
Step 2: On the toolbar below, click on the Merge Cells icon. The result will be executed immediately afterward.
Instructions for Text-Containing Cells:
The steps above won't yield effective results if there's more than one cell being merged containing text. It will take data from the leftmost outer cell to fill in all the merged cells. If you want to merge cells along with all the text content within, you'll need to use a Concatenate function for the new cell after merging. For instance, let's say I have three columns: Last Name, First Name, Full Name. Now, I want to combine data from Last Name and First Name to get the full name result in the Full Name column.
Step 1: Select cell D7, which will be the result cell after applying the calculation function.
Step 2: Enter the formula as follows: =CONCATENATE(B7, ' ' ,C7). Here, B7 and C7 are the two cells you want to merge. ' 'adds a space between them. The Concatenate function is one of the effective string concatenation functions in Excel, and in Google Sheets, the Concatenate function is also supported.
The result will appear once you check the box on the right-hand side.
Here's a guide on merging cells in Google Sheets on Mobile. We hope that with this article, you'll find it easy to merge cells when using Google Sheets on your phone. Similarly, if you use Google Docs for text editing, you can also easily merge columns in a spreadsheet on Google Docs. Learn how to merge columns in Google Docs here.
If you encounter any difficulties during the process, feel free to comment below. Mytour's technical team will be there to assist you.
