+ Reply to Thread
Results 1 to 2 of 2

spacing issues...

  1. #1
    dstiefe
    Guest

    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

  2. #2
    Chip Pearson
    Guest

    Re: spacing issues...

    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" <dstiefe@discussions.microsoft.com> wrote in message
    news:1EA642AA-9AB3-428E-9883-A710F712C835@microsoft.com...
    >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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1