Copy/paste doesn't do this sort of combination of information.But you can easily do it in VBA. If A1 has "Jack" and B1 has "Jill" ...Range("C1").Value = Range("A1").Value & " and " & Range("B1").Value