Reversing a "First Middle Last" Name to "Last, First Middle" Name Format

[KevCarter]

I'd prefer:

=MID(TEXT(A2,"@ @"),SEARCH(" ",A2)+1,LEN(A2))

In VBA

function F_snb(c00)
  F_snb=split(c00)(1) & " " & split(c00)(0)
end function

in Cell B2

=F_snb(A2)

WOW, I never got close to anything that looks like that. I have so much to learn. Thank you very much for taking the time in helping me!

Kevin