+ Reply to Thread
Results 1 to 3 of 3

How do I transpose Comma Separated Data in each cell and delete t.

  1. #1
    randy
    Guest

    How do I transpose Comma Separated Data in each cell and delete t.

    I need to switch a names list in each cell:
    [LAST_NAME, FIRST_NAME]
    to
    [FIRST_NAME LAST_NAME] (no comma),
    preferably into two cells:
    [FIRST_NAME] [LAST_NAME]

  2. #2
    Jason Morin
    Guest

    Re: How do I transpose Comma Separated Data in each cell and delete t.

    Last Name:

    =LEFT(A1,FIND(",",A1)-1)

    First Name:

    =MID(A1,FIND(",",A1)+2,999)

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I need to switch a names list in each cell:
    >[LAST_NAME, FIRST_NAME]
    >to
    >[FIRST_NAME LAST_NAME] (no comma),
    >preferably into two cells:
    >[FIRST_NAME] [LAST_NAME]
    >.
    >


  3. #3
    CyberTaz
    Guest

    RE: How do I transpose Comma Separated Data in each cell and delete t.

    You may be able to just select the column of names and use Data>Text to
    Columns. Specify Comma Delimited in first & second step |:>)

    "randy" wrote:

    > I need to switch a names list in each cell:
    > [LAST_NAME, FIRST_NAME]
    > to
    > [FIRST_NAME LAST_NAME] (no comma),
    > preferably into two cells:
    > [FIRST_NAME] [LAST_NAME]


+ 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