View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default How do I change "Doe, John" to "John Doe" in Excel?

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

--
Kind regards,

Niek Otten

"Moon" wrote in message
...
Imported text from another program shows "Doe, John". Does anyone know
how
to break it into "John" and "Doe"?