Quantcast

MS Excel : swapping name order

LordOpie

MOTHER HEN
Oct 17, 2002
21,027
3
Denver
I have a file that has, in one cell, <last name, first name> and I'd like to swap the order.

Whatcha think?
 

H8R

Cranky Pants
Nov 10, 2004
13,965
35
I have a file that has, in one cell, <last name, first name> and I'd like to swap the order.

Whatcha think?
Just a cell or a whole row or column?

There must be some kind of un-concatenate formula.
 

$tinkle

Expert on blowing
Feb 12, 2003
14,591
5
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.
 

LordOpie

MOTHER HEN
Oct 17, 2002
21,027
3
Denver
Just a cell or a whole row or column?

There must be some kind of un-concatenate formula.
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