We often import data, including text, from different sources into Excel. Sometimes this text requires some cleaning such as removing spaces and adding consistency to the text. This post demonstrates how to use trim() and proper() functions to clean text in Excel. I have the following text that needs...