I need to change "Jane S-Doe" to "S-Doe, Jane" in the same cell. Help appreciated.

[Gamerade]

I have a bunch of names in the following format. Each name is in it's own cell

All of them have {First name> S- > Last name}

Example:
Jane S-Doe

I would like it to be: {S- > Last name, > First name}

Example:
S-Doe, Jane


Is there a way to do this automatically with a formula or macro?

 

[paulrit]

if all the names are in the same format, you can just use text to column feature and split the names in two cells. Then use concatenate function to combine both, in the desired order.

Paul

 

[Gamerade]

That fixed it!

Can't thank you guys enough.

 

[datadata]

Data, not sure how yours is "correct". It only seems to work for "Jane S-Doe" and names of the exact same length, but not names longer or shorter. And it still leaves out the comma between the last and first name.

CMS jr's just needs to add the -1 at the end to get rid of the trailing space.

Cheers...you're right.
Correction:
=CONCATENATE(MID(A1,FIND(" ",A1)+1,255),", ",LEFT(A1,FIND(" ",A1)-1))