Learn Excel Trim Function

Career Guidance
1 follower
Oct 31, 2024
Service desk Analyst complete course
https://www.udemy.com/course/it-support-help-desk-service-desk-analyst-crash-course/?referralCode=2BEA91E82EF0A43B7F09
Citrix virtual apps and Desktop complete course
https://www.udemy.com/course/citrix-virtual-apps-and-desktops-7x/?referralCode=B4AFFADD3E44142E746D
please do use the above link only while buying the course so I will get max amount.
The next function we'll look at is the trim function.
The trim function is used to remove irregular text spacing and keep single spaces between words.
Irregular spacing is unnecessary spacing within the dataset that can occur before,
after, or in between text or numbers within a cell.
It is written as equals to trim.
To use this function on a single cell, we write equals to trim, then select the cell.
To use it on multiple cells, we write equals to trim, set the start, and set the end.
Take a look at this data.
You notice irregular spaces in the last name.
Cell C4 has space before the name.
Same with cells C7 and C9.
Let's try to fix this.
We have equal to trim, bracket, connect, send, close bracket.
Equal to trim, connect the cell, and close.
Let's try it again for proper understanding.
Now, notice that the space behind the S is gone.
The trim can be used to remove unwanted space from the left, from the right, and in between text.
The trim would leave your text having just one space in between.
It will remove any unwanted space before your text, in between your text, and after your text.
