Results 1 to 4 of 4

UnConcatenate?

This is a discussion on UnConcatenate? within the Excel Questions forums, part of the Question Forums category; Can anyone tell me how to unconcatenate? I need to break out column A1 which has names like Smith, John ...

  1. #1
    New Member
    Join Date
    Aug 2006
    Posts
    1

    Default UnConcatenate?

    Can anyone tell me how to unconcatenate? I need to break out column A1 which has names like Smith, John

    into B1 = John and C1= Smith

    Everytime I do it I get the comma after Smith in C1 is there a way to grab just Smith without the Comma?

    Thanks

  2. #2
    MrExcel MVP, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default

    Data\Text to columns\Comma delimited.
    Kristy

  3. #3
    Board Regular PA HS Teacher's Avatar
    Join Date
    Jul 2004
    Location
    Rochester, NY
    Posts
    2,838

    Default

    Highlight Column A.
    Go to the Data Menu
    Select Text to Columns
    Use , as the delimiter
    Recent Draftee
    www.mrexcel.com/board2/viewtopic.php?t=199272
    Recently came across a Free 1 GB Storage/File Sharing Site www.box.net

  4. #4
    Board Regular yee388's Avatar
    Join Date
    Mar 2004
    Location
    Spring, TX
    Posts
    1,374

    Default

    The best solution is what has been mentioned above. However, if you were trying formulas and just want to see how to do it with formulas, here is one way:

    For the First Name: =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
    For the Last Name: =LEFT(A1,FIND(",",A1)-1)

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com