+ Reply to Thread
Results 1 to 5 of 5

Pulling out single names from a string of names

  1. #1
    Forum Contributor
    Join Date
    05-01-2006
    Location
    Erie, Pa USA
    MS-Off Ver
    Vista - Excel 2003
    Posts
    132

    Question Pulling out single names from a string of names

    I have a list of names in a single cell. They are all seperated by a comma, then a space.

    Example would be: John Smith, Steve Wilson, Wallace O Malley, etc.

    What formula could I use to pull out the names individually, starting from the farthest right?
    Last edited by HBF; 09-01-2009 at 01:16 PM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Pulling out single names from a string of names

    A quick way to get the names separated out is using Data --> Text-to-Columns.

    In the Text-to-Columns dialog, select Delimited, then set 'Comma' as the delimiter and click Finish.

    To extract them from the right first would require a function or vba. If I wasn't leaving in one minute for the next few days I'd get that hashed out for you, so maybe someone else can assist...

    Hope that helps!

  3. #3
    Forum Contributor
    Join Date
    05-01-2006
    Location
    Erie, Pa USA
    MS-Off Ver
    Vista - Excel 2003
    Posts
    132

    Re: Pulling out single names from a string of names

    That did it. Thanks Paul.

  4. #4
    Registered User
    Join Date
    02-23-2013
    Location
    albania
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Pulling out single names from a string of names

    can someone help me pls. I need a formula to conect sheets. i put a name in a related date and to other sheet put a 1 at same date but have already a list. i dont know how to explain but ill send an example.
    sheet1 1-Febb 4-Febb 5-Febb the list of names is here
    name
    paul 1
    jesie 1 1

    sheet2 when i paste a name here on sheet1 gets 1 one the row of this person at same date
    1-Febb 4-Febb 5-Febb

    paul jesie
    jesie

    i hope i explained what i mean

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pulling out single names from a string of names

    @besmir

    Please read the forumrules.

    I put an link below.

    http://www.excelforum.com/forum-rule...rum-rules.html

    It's not allowed to ask for help in a question of somebody else.

    Please start your own question.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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