An easier way to flip FirstName LastName to LastName, FirstName
Is there an easier way to flip FirstName LastName to LastName,First Name besides running a macro? There must be a simpler formula – any advice?
Try this
=MID(A1,SEARCH(” “, A1)+1,99)&”, “&LEFT(A1,SEARCH(” “,A1)-1)
