spacing issues...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dstiefe - 21 Mar 2006 22:35 GMT

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

Reply to this Message

Chip Pearson - 21 Mar 2006 23:10 GMT

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

Signature

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

>I have a list of names that have a space in the beginning. For
>example:
[quoted text clipped - 7 lines]
>
> Thank you

Reply to this Message