Learn How to Use Microsoft Excel TRIM Function
In this article, you will learn how to use the Microsoft Excel TRIM function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel TRIM function return value and syntax with the help of some examples.
Microsoft Excel TRIM Function
The Microsoft Excel TRIM function is used to remove extra spaces from the text. That means with the TRIM function, you can able to strip additional spaces from the text string, which will leave only a single space between the words and no space characters at the start or end of the text.
TRIM Function Return Value
It will return the specified text with extra spaces removed.
TRIM Function Syntax
Where the arguments:
- text: It is the text string from where you want to remove the extra spaces.
How to Use the Microsoft Excel TRIM Function?
As we know, the TRIM function removes the extra spaces between the text, which will leave only a single space between the words with no space characters at the start and end of the text. The TRIM function is useful when you want to clean the texts that have been imported from other applications.
You can only remove the ASCII space character, which is 32, from the text. The Unicode text usually contains a text with non-breaking space characters that can't be removed by the TRIM function.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel