Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet from an outside organization. They have first and last name in the same field separated by comma. I know there is some way to extract the name and put in another column but I can not figure it out since each name is a different length.
    Please help!

    Thanks,
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    If your name is in A1 then you could put the following formulae in B1
    =LEFT(A1,FIND(",",A1,1)-1)
    and in C1 you could have
    =RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If necessary, insert an empty column to the right of the column with names.
    Select the column or cells with names.
    Select Data | Text to Columns...
    Specify Delimited and click Next.
    Tick the check box for Comma as delimiter (and possibly that for Space), then click Finish.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans....

    There are so many little features in all the MS products. How does someone find the time to learn them all??
    It worked like a charm.

    Deb

Posting Permissions

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