How to Remove Whitespace From a String in Excel. Rarely is formatting perfect when you copy data from external sources into Microsoft Excel. As an example, you might copy business data from an ...