Title: TRIM in Excel (Formula, Examples) | How to Use Excel TRIM Function?
Headings: Excel TRIM Function
Excel TRIM Function
Excel TRIM Function (Table of Contents)
TRIM in Excel
TRIM Formula in Excel
Trim function arguments
Shortcut of using the formula
Steps for using the Trim function in Excel
How to Use the TRIM Function in Excel?
Example #1
Example #2
Explanation of the TRIM Function in Excel
=LEN (A16)-LEN (TRIM (A16))
=LEN (A16)-LEN (SUBSTITUTE (A16,” “,””))
Things to Remember
Recommended Articles

Content: Write the formula =TRIM (CLEAN (A16))
The Result is : The cursor Position to the lower right corner of the formula cell (B16 in this example)
Select the range and fill down the column with the formula. The Result is: Then you need to copy and paste values only, not formulas like in the first example. Explanation of the TRIM Function in Excel
Before removing spaces in data, if we want to know how much extra space or total space in the excel sheet, we get the LEN function’s help with a trim function. If you want to get the total numbers of extra spaces in a cell, then, first of all, we find the total numbers of text length using the Len function, then calculate the string length without extra spaces and subtract the latter from the total length. The formula is as showing below mention. =LEN (A16)-LEN (TRIM (A16))
The following screenshot shows the above formula in action: The Result is: Note: