change order of name in cell

[Wookie]

I have a file with peoples names in column A in format
Bloggs, Joe
Smith, John

I want in column B to have
Joe Bloggs
John Smith

any ideas?

 

[Richard Schollar]

Hi

Maybe:

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

 

[DominicB]

Good afternoon Wookie

If your column starts in row 1 and strictly follows the format you have indicated then something ike this should suffice :

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & LEFT(A1,FIND(",",A1)-1)

Just copy it to the bottom.

HTH

DominicB

 

[Wookie]

thanks