Clears all spaces in the text except single spaces between words. You can use the function TRIM when retrieving text with irregular spaces from other applications.
SyntaxTRIM(text) Text Text whose spaces need to be cleared.
The TRIM function is used when we want to remove extra spaces from the text.
Its function is to remove the spaces at the beginning and end of the string, but retain the spaces inside the string that serve as separation between words.
Let's do some practical operation in this form to help everyone understand:
Suppose we want to clear the first space character in the text in cell A2.
First select cell B2, click Insert Function, find the TRIM function, and click OK.
Here, we select A2 to fill in the string. You can see that there are unremoved spaces at the beginning and end of the string when filling in.
Click OK, the result after removing the leading and trailing spaces will be displayed, and the spaces between words will be retained.
This function is simple and easy to use, have you learned it~
评论列表(196条)
测试