Remove space in character one

[Annette]

I need to remove a space left in front of text ... in column A and column D
to clean up the ss so that a sort can be done. How would I do that through
code?

 

[Frank Kabel]

Hi
try
=TRIM(A1)
or
=TRIM(D1)
and copy down

 

[JE McGimpsey]

See David McRitchie's TRIMALL() macro:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[Ron de Bruin]

With code you can do this

Sub test()
For Each cell In Columns("A").SpecialCells(xlCellTypeConstants)
cell.Value = Trim(cell.Value)
Next
End Sub

 

[JE McGimpsey]

Another alternative:

Public Sub LeftTrimAandD()
Dim rCell As Range
On Error Resume Next
For Each rCell In Range("A:A,D").SpecialCells( _
xlCellTypeConstants, xlTextValues)
With rCell
.Value = LTrim(.Value)
End With
Next rCell
On Error GoTo 0
End Sub

 

[Annette]

Another perfect additon to the project .. thanks, Ron!