View Single Post
  #5   Report Post  
David
 
Posts: n/a
Default

?B?c291dGhlcm4=?= wrote

Cells contain names in last name, first name order. I wish to convert
to first name last name (no comma) without retyping. Thanks


One more way:
=IF(A1="","",RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(",",A1)-1))

--
David