Thread: How do I convert last name, first name in cells to first name las.
View Single Post
  #3   Report Post  
BobT
 
Posts: n/a
Default
=TRIM(MID(A1,FIND(",",A1,1)+2,256)&" "&LEFT(A1,FIND
(",",A1,1)-1))
-----Original Message-----
Cells contain names in last name, first name order. I
wish to convert to
first name last name (no comma) without retyping. Thanks
.

Reply With QuoteReply With Quote