It worked for the first few names but as the length of names changed down the
list, it chopped part of the names.


"HKaplan" wrote:

Try this, where example Henry, John is in cell A1

=RIGHT(A1,FIND(",",A1)-2)&" "&LEFT(A1,FIND(",",A1)-1)

This assumes the field always has the format LastName+comma+blank
+FirstName