How many times have you tried to import a file into Excel, only to
have extra blanks all over the place in the document? Well that’s where
the Trim Formula can come into play. The Trim formula is used to clean
up and remove all the leading and trailing blanks as well as all but
one blank in-between text that you may have in a list of cells. So now
instead of going into each cell one-by-one, there is one formula to do
all the work for you. Let’s take a look at the formula first (it’s a
short one):
=Trim(text)
This formula is very easy to use but can make you job a whole lot easier. Let’s take a look at some of the examples now.
Examples
Example 1: =trim(“ Bird “), will return “Bird”
Example 2: =trim(“ First Second Third “), will return “First Second Third”
Example 3: =trim(A2), will return “Mark Smith”
Example 4: =trim(A5), will return “Gene William Wilder”
Hopefully the few examples I listed above help you to understand how to use this formula and will save you some time the next time nothing seems to line up correctly. If you have any other questions please leave a comment below
=Trim(text)
This formula is very easy to use but can make you job a whole lot easier. Let’s take a look at some of the examples now.
Examples
Example 1: =trim(“ Bird “), will return “Bird”
Example 2: =trim(“ First Second Third “), will return “First Second Third”
Example 3: =trim(A2), will return “Mark Smith”
Example 4: =trim(A5), will return “Gene William Wilder”
Hopefully the few examples I listed above help you to understand how to use this formula and will save you some time the next time nothing seems to line up correctly. If you have any other questions please leave a comment below
No comments:
Post a Comment