Recompiling Names

[b1urrc0ck]

Hi isit possible for excel to find same name and change all the Doe John to John Doe? e.g. John Doe and Doe John.

 

[Satish.digit]

Hi you can use Find replace command for this.


use Ctrl+H and find with "Doe John" and replace with "John Doe"

 

[Faseeh]

Hi b1urrc0ck,


Welcome to the forums!


Or if you have a list in Col A you can use:

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

Regards,