spacing issues...

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" <[email protected]> wrote in message
news:[email protected]...
>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