Results 1 to 4 of 4
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excell (Excell 2000)

    First, make sure that there are enough empty columns to the right of the column of names to hold the name with the most parts.

    Now:

    1- Select the column of names.

    2- Select "Text to columns" on the Data menu.

    3- In the first dialog box click on the radio button next to Delimited.

    4- Click the Next button.

    5- Put check marks next to all of the delimiters that are used to separate the parts of names.

    6- Click on the Finish button.

    The names should now be separated into separate columns.
    Legare Coleman

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excell (Excell 2000)

    See the thread beginning with <post#=197774>post 197774</post#> for the 2 equations that can accomplish this task.

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excell (Excell 2000)

    Thank you very much for your quick and concise help.

  4. #4
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split full name into first and last (Excell 2000)

    Subject edited by HansV to make it more descriptive than 'Excel'.

    Is it possible to separate a proper name (Sam Jones...entered under name), that has been entered in a single cell, into two separate cells (First Name Last Name)? And further, can you separate an entire column of proper names the same way. I realize that I may be asking too much, and just being lazy.

Posting Permissions

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