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"?
|