If Doe,John is in Column A insert a new Column B and enter
=RIGHT(A1,FIND(",",A1,1))&" " &LEFT(A1,FIND(",",A1)-1)
The just Copy the Entire Column B and Edit | Paste Special | Values
over Column A.
"Erin" wrote:
Example it says Doe,John and I want it to say John Doe
|