how to remove all spaces from a cell

Macro 49: Trim Spaces from All Cells in a Range A frequent problem when you import dates from other sources is leading or trailing spaces. That is, the values that are imported have spaces at the beginning or end of the cell. This obviously makes it difficult to do things like VLOOKUP or sorting. Here […]