TRIM (Function to Remove Spaces in Text) in Excel

This updated guide explains how to TRIM (Function to Remove Spaces in Text) in Excel through clear steps, practical examples, and important checks that help prevent common errors.

TRIM (Function to Remove Spaces in Text) in Excel example screenshot 1

The article describes the syntax and usage of the TRIM function in Excel.

Description

The TRIM function is a function that removes all spaces in the input text and keeps a space between words.

You can use this when the text contains a lot of redundant space.

The TRIM function only removes 7-bit ASCII space characters from text, not nonbreaking spaces. This character is often used in web pages as HTML elements.

Syntax

= TRIM (text)

Arguments

text is the text, the text should remove spaces, required parameters. You can enter text or reference directly.

For Example

- Remove spaces in the text "Nguyen Van A"

TRIM (Function to Remove Spaces in Text) in Excel — For Example screenshot 2

- Remove whitespace values in text:

TRIM (Function to Remove Spaces in Text) in Excel — For Example screenshot 3

Thus, the article introduced syntax and examples to help you understand how to use the TRIM function. The way to use TRIM is very simple but effective, it will save you a lot of time processing documents. Good luck!

FAQ

What is the easiest way to TRIM (Function to Remove Spaces in Text) in Excel?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.