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: 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. Let us now see how to use the TRIM function in Excel with the help of some examples. You can download this TRIM Function Excel Template here – TRIM Function Excel Template
Example #1
Suppose we have a column of customer names that have some space before and after the text and more than one space between the words. So, how do we remove all extra space in a cell at a time on overall data by copying an Excel TRIM formula across the column and then replacing formulas with their values? Let’s start to write the formula; the detailed steps are mentioned below: