Removing Whitespace in Google Sheets

Buzz

Ngày cập nhật gần nhất: 15/4/2026

When working on Google Sheets, dealing with unnecessary extra spaces is inevitable. However, Google Sheets offers functions and add-ons to help remove these spaces. Check out the article below to understand more about how to remove extra spaces in Google Sheets.

While Google Sheets may not have as many options and tools as Excel, it remains an efficient spreadsheet application. It also offers similar functions to Excel when it comes to removing extra spaces caused by text input or copying data into cells. Moreover, Google Sheets features the Find and Replace tool and an add-on for quickly eliminating these spaces. Today, Mytour will guide you on how to remove extra spaces in Google Sheets.

Guide to Removing Extra Spaces in Google Sheets

Initiate

Method 2. Utilizing Substitute Function
Google Sheets offers a handy function called Substitute to replace characters within cells. The Substitute function enables users to alter content within cells, including removing spaces. Its syntax is as follows: SUBSTITUTE(text_to_search,search_for,replace_with,[occurrence_number]). This function acts like a 'find and replace' feature to locate characters within cells and replace them with alternatives.
To employ this function, click on cell A5. Then, input the following formula into the function bar: =SUBSTITUTE(B3, ' ', '') and press Enter. The resulting value in A5 will be 345678, devoid of any spaces.

If you wish to replicate this function to clear multiple cells, right-click on the cell containing the formula and drag it to the desired destination.

Method 3: Google Sheets' Find and Replace Tool
Google Sheets includes a useful tool called Find and Replace, allowing for quick search and replacement of characters, digits, and spaces across all cells in a spreadsheet.
Step 1: Select Edit and then choose Find and replace from the toolbar.

Step 2: Select cell A3, input a space into the Find box, and press Enter

Step 3: Keep the Replace with box unchanged. Then, press Done. The system will eliminate any spaces within cell A3

Similarly, if you want to find all, select Replace all, then press Done to remove all spaces.

Method 4: Using Power Tools add-on
Google Sheets also offers a highly valuable add-on called Power Tools.
Step 1: To install this add-on, you can access it Here.
Step 2: Then, click on Free +, and the system will automatically download and install it.

Step 3: Next, select the cell where you want to remove spaces. Click Add-ons -> Power tools -> start to initiate the add-on

Step 4: Choose Remove -> Remove all spaces then press Remove to proceed with removing spaces. Additionally, you can select other options to customize the removal process.

This is a tutorial on how to remove spaces in Google Sheets. Mytour hopes that through this tutorial, you can easily eliminate unnecessary spaces in your spreadsheet. If you encounter any difficulties during the process, feel free to comment below, and Mytour's technical team will assist you.

Frequently Asked Questions

What are the methods to remove extra spaces in Google Sheets?

In Google Sheets, you can remove extra spaces using several methods: the SUBSTITUTE function to replace spaces with nothing, the Find and Replace tool to search for and remove spaces, or the Power Tools add-on for a comprehensive removal process. Each method is effective for cleaning up your data.

How do I use the SUBSTITUTE function to eliminate spaces in cells?

To use the SUBSTITUTE function, enter the formula =SUBSTITUTE(B3, ' ', '') in a cell. This replaces all spaces in the referenced cell (B3) with nothing. After pressing Enter, the cell will display the text without any spaces, allowing you to quickly clean your data.

Is the Find and Replace tool effective for removing spaces in Google Sheets?

Yes, the Find and Replace tool is effective for removing spaces. By selecting the option from the Edit menu, you can input a space in the Find box and leave the Replace box empty. This will remove all spaces from the selected cells when you press Done.

Can I use an add-on to quickly remove spaces in Google Sheets?

Yes, you can use the Power Tools add-on to remove spaces efficiently. After installing the add-on, select the desired cells, navigate to Add-ons -> Power tools -> Start, and choose Remove -> Remove all spaces. This feature streamlines the process of eliminating unnecessary spaces from your spreadsheet.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]