In this article:

How to Remove Whitespace in Google Sheets (2024 Update)

May 8, 2024

How to Remove Whitespace in Google Sheets

Removing whitespace in Google Sheets can clean up your data which makes it easier to analyze, present, and ensure accuracy in calculations. Follow the steps below to remove unnecessary or extra spaces in Google Sheets. 

1. Select the Cells with Whitespace to Clean Up

Select the cells that contain whitespace you want to remove. You can click and drag to select multiple cells or click on a single cell if you're focusing on one spot.

google sheets remove whitespace

2. Open "Find and Replace" from the Edit Menu

With your cells selected, open the "Find and Replace" tool. Go to the "Edit" menu and choose "Find and replace" from the dropdown options.

google sheets remove whitespace formula

3. Input a Space in "Find" and Leave "Replace with" Empty

In the "Find and Replace" dialog box, enter a space in the "Find" field to look for whitespaces. Leave the "Replace with" field empty to remove the spaces entirely.

4. Choose "Specific Range" for Selected Cells or "All Sheets" for Whole Document

Make sure the "Search" option is set to "Specific range" if you've selected specific cells. To remove whitespaces in the entire sheet, you can choose "All sheets."

5. Click "Replace All" to Remove All Found Whitespaces

Click "Replace all" to remove all instances of whitespace in your selected range. Google Sheets will then remove the spaces and tell you how many replacements it made.

6. Close the "Find and Replace" Dialog After Completion

After removing the spaces, close the "Find and Replace" dialog. Click the "Close" button or the "X" at the top right of the dialog box.

We hope that you now have a better understanding of how to remove whitespace in Google Sheets. If you enjoyed this article, you might also like our article on setting up Google Sheets non contiguous range or our article on setting up a Monte Carlo simulation in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->