Convert cell from last name first to first name first

[Guest]

Can this be done:

Mary Smith instead of Smith, Mary?

Thanks,

Diane

 

[JE McGimpsey]

See

http://cpearson.com/excel/FirstLast.htm

 

[Guest]

I have a list of names:
Smith, Mary J.
I need to convert to:
Mary J. Smith in the same cell.

Does that make sense?

Thanks,
Diane

 

[Paul Corrado]

You cannot convert them in the "same cell" without VB and that is probably
not necessary.

Use the formula on Chip's site in a helper column and then Copy/Paste
Special the converted names back over the original data.

 

[JE McGimpsey]

One way:

=TRIM(MID(A1,FIND(",",A1)+1,255)&" "&LEFT(A1,FIND(",",A1)-1))