TRIM

  • Thread starter Thread starter Guest
  • Start date Start date
Move your mouse up near the column header, on the right side. When it changes
into the <-|-> symbol, double click, and Excel will auto-size your column
for you.
 
Without entering a formula and copying down, try a macro to TRIM the entire
column in place.

Sub TRIM_EXTRA_SPACES()
Dim cell As Range
For Each cell In Selection
If (Not IsEmpty(cell)) And _
Not IsNumeric(cell.Value) And _
InStr(cell.Formula, "=") = 0 _
Then cell.Value = Application.Trim(cell.Value)
Next
End Sub


Gord Dibben MS Excel MVP
 
Back
Top