TRIM

[Guest]

How do I Trim extra space in a column?

 

[Guest]

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.

 

[Guest]

=trim(a1) and drag down

 

[Gord Dibben]

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