How to Remove Spaces in Excel Online with ZKutools Anywhere for Excel

Extra spaces in Excel data can cause a variety of problems. They can affect sorting, filtering, lookups, formulas, data imports, and overall data consistency. While Excel Online provides some built-in functions for trimming spaces, they often require formulas, helper columns, and additional cleanup steps.

With ZKutools Anywhere for Excel, you can quickly remove unwanted spaces from selected cells using a dedicated Remove Spaces feature. Whether you need to remove leading spaces, trailing spaces, extra spaces between words, or all spaces entirely, the task can be completed in just a few clicks.

In this article, you'll learn when to use the Remove Spaces, how it compares with Excel Online's built-in methods, and how to use each option effectively.

Common Use Cases

The Remove Spaces feature is useful in many real-world scenarios:

• Cleaning imported data from databases or websites
• Preparing customer lists for analysis
• Standardizing names and addresses
• Fixing lookup and matching errors caused by hidden spaces
• Cleaning product codes and identifiers
• Preparing data for reporting and export

Instead of manually editing cells one by one, you can clean hundreds or thousands of records at once.

Remove Spaces vs. Excel Online Built-in Methods

Excel Online provides functions such as:

• TRIM()
• SUBSTITUTE()
• CLEAN()

While these functions are useful, they have several limitations:

Excel Online Method

• Requires formulas
• Often needs helper columns
• Different space problems may require different formulas
• Results must often be copied and pasted back as values
• Not beginner-friendly

ZKutools Anywhere for Excel's Remove Spaces

• No formulas required
• Multiple space-removal options in one tool
• Preview results before applying
• Works directly on selected cells
• Faster and easier for large datasets

For users who regularly clean imported or inconsistent data, the dedicated Remove Spaces tool can save significant time.

How to Use Remove Spaces in Excel Online

Using the feature is simple:

Step 1: Install ZKutools Anywhere for Excel

First, install the ZKutools Anywhere for Excel add-in for Excel Online.

For installation instructions, refer to:

How to Install ZKutools Anywhere for Excel

Step 2: Select the Data

Select the cells that contain unwanted spaces.

Step 3: Open Remove Spaces

Click:

The Remove Spaces dialog box will appear.

Step 4: Choose an Option

Select the space-removal option that best fits your needs:

• Remove Leading Spaces
• Remove Trailing Spaces
• Remove Leading and Trailing Spaces
• Remove Excess Spaces
• Remove All Spaces

Step 5: Preview the Results

The Preview area displays the processed results before any changes are made.

Review the results to make sure they meet your expectations.

Step 6: Apply the Changes

Click:

The selected cells will be updated immediately.

Option Examples

Example 1: Remove Leading Spaces

Original:

   Product A

Option:

Remove Leading Spaces

Result:

Product A

Example 2: Remove Trailing Spaces

Original:

Product A   

Option:

Remove Trailing Spaces

Result:

Product A

Example 3: Remove Leading and Trailing Spaces

Original:

   Product A   

Option:

Remove Leading and Trailing Spaces

Result:

Product A

Example 4: Remove Excess Spaces

Original:

New     York     City

Option:

Remove Excess Spaces

Result:

New York City

Example 5: Remove All Spaces

Original:

AB 123 456

Option:

Remove All Spaces

Result:

AB123456

This option is especially useful for product codes, serial numbers, account IDs, and imported identifiers.