15 functions in Excel for any user - Part 1

Today I will talk about Excel functions, one of the most important tools in Excel. We will create a list of 15 functions not very used but that can be very, very useful at some point. This entry is the 1st of 2 entries. Here it goes!

1. Remove the spaces from a text except single spaces between words

Sometimes the data are cluttered, dirty, with spaces where you do not want to have, right? As one of the most useful ways to help you clean your data is the TRIM function.

This function removes all spaces from a string except for single spaces between words. Let us examine an example.

=TRIM("The     wizard     of     Excel      ") = The wizard of Excel


The function has removed those spaces before, after and in between to leave the text clean and ready for analysis.