Delete Characters Before First character In Text String

[hmk]

Hello

Is there a vba code to Delete any spaces before the first character In Text String in cell ?


Thanks

 

[dave3009]

Very simple, this method used a selected range but if you want a specific range you can change it easily

Sub trimspace()
Dim my, c As Range
Set my = Selection
For Each c In my
    c.Value = Trim(c.Value)
Next
End Sub

 

[hmk]

Thank u V much