Can someone please help me with the formula issue.
I am trying to turn Smith, John into John Smith
I am using the following code =MID(E6&" "&E6,FIND(" ",E6)+1,LEN(E6))
After applying the formula I get this John Smith,
Is there something I can add to the formula that will delete the comma? I tried the find/replace but it doesn't work in the corrected field and I would like to not use the find/replace function for all the names I will have to sort through. I was hoping for one formula that could do it all then I could fill down on all of the names.
Thanks
Bookmarks