Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Peoples names - one column to two columns (Excel 2003 SP1)

    I am sure this is around somewhere - I have done some searches, but have not been able to find anything.

    The Situation : I have been given a spreadsheet with names, phone numbers and e-mail addresses etc. The names are in one column - first, last - separated by a space. I want to break them out so the first names and last names are in separate columns. I suspect that there are macros out there somewhere that will do this. My VBA leaves a lot to be desired. Any insight that anyone can give me will be greatly appreciated. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

    Thanks in advance.

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Peoples names - one column to two columns (Excel 2003 SP1)

    Make sure that there are enough blank columns to the right of the column that contains the names to hold the separated names. Then do the following:

    1- Select the column containg the names by clicking on the letter at the top of the column.

    2- Click on the "Text to columns..." command in the Data menu.

    3- In the first dialog box, select Delimited (make sure it has a dot next to it). Click on the Next button.

    4- In the next dialog box, put a check mark next to "Space". Click on the Finish button.

    The names should now be separated.
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Peoples names - one column to two columns (Excel 2003 SP1)

    Wow!!! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> I was unaware that this type of functionality even existed within Excel. Legare, thank you very much for this. Something new everyday. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> (an extra one for today)

Posting Permissions

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