Get How To Remove White Space In Excel Cell Background. Trim function can remove leading and trailing spaces in text, double spaces. Excel's trim function will remove all but one space between words;

My google searching suggests this can only be done with vba.

My google searching suggests this can only be done with vba. This post shows you how to remove leading spaces (at the start of the text) and trailing spaces (at the end of the text) in excel. Choosing delete cells deletes only the blank cells in the previously selected range. The image below shows the contents that we have copied from other sources.