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?

via 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? | LinkedIn.

Try this

=MID(A1,SEARCH(” “, A1)+1,99)&”, “&LEFT(A1,SEARCH(” “,A1)-1)

I cobbled this code together for someone at work. They wanted to unhide rows if some cells contained Yes.

The control cells were D4, D5 & D6. You should be able to reuse this code.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


Peter Noneley      Excel Function Dictionary Updated Oct 2009 – no macros or VBA code, smaller file size. The Excel Function Dictionary contains over 150 examples of functions.

via www.xlfdic.com Excel Function Dictionary 150 example functions and formula..

Click to Download