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: Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
TRIM Formula in Excel
Below is the TRIM Formula in Excel: Trim function arguments
There is only one argument in the Trim function, which is below mention. =Text (Cell Value / Text)
Shortcut of using the formula
Click on the cell where you want to result in value then put the formula as below mention
= Trim (Cell Value / Text)
Steps for using the Trim function in Excel
Click on formula tab > Text > click on Trim
Also, click on the function icon, then manually write and search the formula. We get a new function window showing in below mention pictures. Then we have to enter the details as shown in the picture. Put the Cell value or text value where you want to remove space from data. Then Click On OK. The Result is: How to Use the TRIM Function in Excel? Trim Function in Excel is very simple and easy to use.