TRIM
 

How do I Trim extra space in a column?

TRIM
 

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.
--
Best Regards,

Luke Moraga


"s99drf" wrote:

How do I Trim extra space in a column?

TRIM
 

=trim(a1) and drag down

"s99drf" wrote:

How do I Trim extra space in a column?

TRIM
 

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

On Fri, 27 Apr 2007 06:38:10 -0700, s99drf
wrote:

How do I Trim extra space in a column?