Trim Cells using VBA in Excel - Stack Overflow
This works well for me. It uses an array so you aren't looping through each cell. Runs much faster over large worksheet sections. Sub Trim_Cells_Array_Method() Dim arrData() As Variant Dim arrReturnData() As Variant Dim rng As Excel.Range Dim lRows As Lon...