I have a list of names that have a space in the beginning. For example:

" Daniel james"
" Michael james madison"

The list of names has a space before the "D" and the "M" in this example.
How do I loop through the column and delete/remove the space?

Thank you

Select the cells and run the following code:

Sub AAA()
Dim Rng As Range
For Each Rng In Selection.Cells
Rng.Value = LTrim(Rng.Text)
Next Rng
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dstiefe" wrote in message
...
I have a list of names that have a space in the beginning. For
example:

" Daniel james"
" Michael james madison"

The list of names has a space before the "D" and the "M" in
this example.
How do I loop through the column and delete/remove the space?

Thank you