How to separate a name lumped together

I downloaded a bunch of data but the names (350+ of them) are all listed exactly like this: Harden, JamesJames Harden

How can I manipulate this to look like this: James Harden

Thank you in advance.

Assuming that string is in A2, put this formula in B2:

=MID(LEFT(A2,LEN(A2)/2+1),FIND(",",A2)+2,255)&" "&LEFT(A2,FIND(",",A2)-1)

then copy down as required.

Hope this helps.

Pete

Thanks Pete, it's almost there. The result is this: JamesJ Harden

Thanks Beamernsw but same as Pete's. The result is: JamesJ Harden

Why wouldn't it work for me? Do you have a different version? I have excel 2013.

Perhaps you have more or fewer spaces than shown in your single example. Attach a sample workbook and it will be clearer to us.

Pete

I can't figure out how to attach a file to this existing post.

figured it out. see attached. TY

Yes, you had two spaces at the end of your names. Try this formula in B2 instead:

=MID(LEFT(TRIM(A2),LEN(TRIM(A2))/2+1),FIND(",",A2)+2,255)&" "&LEFT(A2,FIND(",",A2)-1)

then copy down.

Hope this helps.

Pete