EXCEL FUNCTION – TRIM

EXCEL FUNCTION – TRIM

How to use “TRIM” function in Excel

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:
=TRIM(text)
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

Example 1: Exploring “TRIM” function with examples:

Here we have some examples, where “Column A” has various scenarios and “Column B” shows the output of the function. Explanation is also provided in Column “C”. We will be using TRIM function as follows:

TRIM Function
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 string manually (one by one) is very difficult and TRIM Function helps to apply in large database at once and makes the work easy, saves time and increases efficiency.

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs

Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business