The function TRIM

Does your data in Excel have unnecessary blank spaces? That could affect future formulas and calculations, plus it doesn't look professional. So how do you fix the problem? Do you retype the information again without the blank spaces?

Excel has a formula (TRIM) that cleans up blank spaces for you; regardless whether the spaces are at the beginning or at the end of the word or a sentence.

In BEFORE, example 1, the blank spaces are at the beginning of the sentence. In example 2, the spaces are scattered throughout the sentence. In example 3, the spaces are at the end of the sentence, which is invisible to the naked eye. This will be detrimental later on when using it in a formula (Excel doesn't like blank spaces in a formula). In AFTER, the examples have no blank spaces because we used the function TRIM to remove them.


Write a comment

Comments: 0