MS Excel : swapping name order

[LordOpie]

I have a file that has, in one cell, <last name, first name> and I'd like to swap the order.

Whatcha think?

[LordOpie]

nevermind, found "text-to-column" under "Data" menu and that was easy :)

[H8R]

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]

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]

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