When we work on Google Sheets, the appearance of extra spaces is very unavoidable, however, Google Sheets also has functions and add-ons to do this. Here to better understand how to remove spaces in Google Sheets.
Google Sheets may not have as many options and tools as Excel, but it will always be a great calculator. It also has the same functions as Excel when we delete extra space when typing text, or maybe by copying data into worksheet cells. What’s more, Google Sheets has a Find and Replace tool and an add-on to quickly remove these spaces. Today, Taimienphi.vn will guide you how Delete spaces in Google Sheets.
Instructions for clearing spaces in Google Sheets
HOW TO REMOVE WHITE SPACES IN GOOGLE SHEETS
Method 1: Use the Trim function
Google Sheets has the same function Trim Like Excel, the Trim function allows us to remove spaces from cells to spaces in letters.
Step 1: Open a new Google spreadsheet and fill in cell A3 with the value “345 678” with 2 spaces at the beginning and the end plus 3 spaces between 2 numbers.
Step 2: Next. select cell A4 and click on fx bar. Enter the formula as follows: ‘= TRIM (A3)’ then press Enter. The result is that cell A4 has the same sequence of numbers as cell A3 but with only a space in between
Method 2. Use the Substitute function
Google Sheets also has a function Substitute To replace letters in cells, Substitute allows users to change the content of cells, and we can also remove spaces with this function. Structure for the function Substitute as follows: SUBSTITUTE (text_to_search, search_for, replace_with,[occurence_number]). This function is like the “search and replace“to find the letters in the cells and replace them with something else.
To use this function, click in cell A5. Next, enter the fx bar as follows: = SUBSTITUTE (B3, “”, “”) then press Enter. The result returned in cell A5 is number 345678, without any spaces.
If you want to copy this function to delete different cells, right-click the cell containing the formula and drag and drop where you need to copy.
Method 3: Find and Replace tool of Google Sheets
Google Sheets has a support tool that is Find and Replace, with it you can find and replace letters, numbers, and spaces quickly in every cell in your spreadsheet.
Step 1: You choose Edit then select Find and replace on the toolbar
Step 2: Select cell A3, enter a space in the box Find then press Enter
Step 3: In the box Replace with you stay the same. Then press Done. The system will remove the spaces in cell A3
Do the same if you want to find it all, you choose Replace all then select Done to remove all spaces.
Method 4: Use the Power Tools add-on
Google Sheets also has a very valuable add-on Power Tools.
Step 1: To install this add-on you can access Here.
Step 2: Next, click on Free +, the system will automatically download and install.
Step 3: Next, select the cell you want to remove the space from. Click Add-ons -> Power tools -> start to start the add-on
Step 4: You choose Remove -> Remove all spaces then press Remove to proceed to delete the spaces. In addition, you can also choose other options to delete at your disposal.
Above is the article how to guide Delete spaces in Google Sheets. Taimienphi.vn hope that through this article, you can easily remove redundant spaces in your spreadsheet. If in the process of implementation you encounter difficulties, do not be afraid to comment below, Taimienphi.vn technical team will support you.