Quantcast

MS Excel : swapping name order

Discussion in 'Computers & Technology' started by LordOpie, Apr 16, 2008.

  1. LordOpie

    LordOpie MOTHER HEN

    Rep/Likes:
    0 / 0
    Joined:
    Oct 17, 2002
    Messages:
    21,033
    Location:
    Denver
    I have a file that has, in one cell, <last name, first name> and I'd like to swap the order.

    Whatcha think?
     

    Please register to disable this ad.

  2. LordOpie

    LordOpie MOTHER HEN

    Rep/Likes:
    0 / 0
    Joined:
    Oct 17, 2002
    Messages:
    21,033
    Location:
    Denver
    nevermind, found "text-to-column" under "Data" menu and that was easy :)
     
  3. H8R

    H8R Cranky Pants

    Rep/Likes:
    7 / 4
    Joined:
    Nov 10, 2004
    Messages:
    13,983
    Just a cell or a whole row or column?

    There must be some kind of un-concatenate formula.
     
  4. $tinkle

    $tinkle Expert on blowing

    Rep/Likes:
    4 / 5
    Joined:
    Feb 12, 2003
    Messages:
    14,846
    my next deliverable will have to suck non-standardized (except for column names) spreadsheets saved as .xml through a web portal & populate a db.

    i'm not looking fwd to it.
     
  5. LordOpie

    LordOpie MOTHER HEN

    Rep/Likes:
    0 / 0
    Joined:
    Oct 17, 2002
    Messages:
    21,033
    Location:
    Denver
    See post #2... fortunately for me, the cells were deliniated with a comma, so it was actually really simple, but thanks bro!


    $tink, that's why you get the big bucks! :D