Excel TRIM Function
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
These are the non-value added spaces and generally arises when data is imported from any other sources.
Syntax:-
Syntax Description:
text argument [Required] is used to give the text or cell reference for which additional spaces to be removed
TRIM Function has only one “Required” arguments i.e. text
There is only one argument in the Trim function, which is below mention.
=Text(Cell Value / Text)
Example 1: Exploring “TRIM” function with examples:
Here we have some examples, where “Column A” has various scenarios there is a problem of spaces. Words doesn’t have proper spacing it looks untidy and “Column B” shows the output of the function. Where formula of TRIM is applied and we can see after applying the formula extra spaces removes The explanation is also provided in Column “C”.
Example #2
Generally when we collect data in excel from another application or any database like Server, Oracle, or HTML, we face various issues for line breaking with extra space; we can say that double line issue or wrap text issue, and also ever include with a special character which is not removed with only trim. So we can use a trim function with a clean function for such type situations. Example given below:-
In this type of scenario will use TRIM CLEAN Formula.
Formula =TRIM(CLEAN(A16))
With the help of the TRIM Clean formula, the data will be cleaned, removing all spaces, and correcting the positions of words.
Advantage of TRIM Function:
TRIM function is very advantageous in many ways. It helps for the document imported from any other sources and data is not correctly synchronized.
Removing spaces in available strings manually (one by one) is very difficult. TRIM Function helps apply in large databases at once, makes the work easy, saves time, and increases efficiency.
Download Practice File
Recommended Articles
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
