Today, we are going to remove unnecessary spaces. Sometimes, there’s a space at the beginning of text, sometimes, there are more than one space between two words, and sometimes, there are some spaces at the end. The last ones are the hardest to notice (Fig. 1)
The name in the first line, Brave Brandon with a space at the end, is something different for Excel, than Brave Brandon without a space. In such a case, we want to use the TRIM function to remove the space (Fig. 2)
After copying it down, we have our names without unnecessary spaces (Fig. 3)
This simple function removes unnecessary spaces from the beginning, the end, and the middle of text beetween words only leaves one space.