This assumes that the first and last name is separated by a space and there are no other spaces. Also, if the last name is greater than 10 characters, it will only return the first 10. The name is in the A1 cell: =CONCATENATE(MID(A1,FIND(" ",A1,1)+1,10),", ",LEFT(A1,FIND(" ",A1,1)-1)) As always, there is probably a better way to do this.