TRIM (function to remove spaces in text) in Excel

When the data you copy or download online appears a lot of redundant white space, you will lose a lot of time if you manually remove the white space. The TRIM function will help you eliminate spaces quickly with a lot of data.

TRIM (function to remove spaces in text) in Excel Picture 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)

Inside:

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 Picture 2

- Remove whitespace values in text:

TRIM (function to remove spaces in text) in Excel Picture 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!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

How to separate text strings by commas or spaces in Excel
separating text strings based on commas or spaces is a trick that helps you split the characters in a parameter cell into different clusters based on commas or spaces that parameter cell contains. tipsmake will guide you how to separate text strings by commas or spaces in excel.
Tips to remove extra spaces between words in Microsoft Word
in the process of editing documents in microsoft word, there are times when you have a text with lots of extra spaces between words, which makes the text fragmented and unclear.
How to create space after comma in Excel
to create a space after a comma in excel, you can use a function or immediately use an available tool to do it, with a quick and very simple method.
How to use the TEXTJOIN function in Excel 2016
the textjoin function concatenates text from multiple ranges and / or strings, which includes a delimiter between the connected text value. if the delimiter is an empty text string, this function effectively matches the ranges.
How to Remove spaces and carriage returns in Word
knowing the tips of removing spaces as well as newlines in word in the latest versions is a great advantage for you, because in the text editing process on this tool, there will be times when spaces appear. and many errors, of which the automatic newline error is an example.
The LEFT function, how to use the left-hand string cutting function in Excel
the left function in excel is used to trim the left string of characters in data parameters.
How to use the SUMIF function in Excel
the sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.
The Text function converts a numeric value into text in Excel
in the process of working with excel, when the requirements of the job you need to convert from the number format to text format with the specified format suitable for the purpose of use. the text function will help you do that.
SUBSTITUTE function - The function replaces text strings in Excel
in the course of working you have excel data file need to change a series of data over the years. with a simple operation, you can change all that data. the following article details the substitute function - the function replaces the text string in excel.
The MID function in Excel, how to use the MID function, and examples
the mid function in excel, how to use the mid function, and examples. the mid function in excel is a function of the text function group, you use the mid function if you want to cut the string in the middle of the text string when processing the string. if you do not know or do not understand the mid function, then you