Need to change order of first name last name

[kmsprague]

Hi all!
I need a formula that will help me to change the order of first name and last name. The hard part is that the report from the system has the name listed as First Name Last Name - Employee Number. The number of characters is different with each employee and the only delimiter that I have is the hyphen, which is also in some people's names. I need it to be Last Name, First Name to work with the other reports I'm using. Any ideas? All help is greatly appreciated!!

 

[Fluff]

How about

=TEXTJOIN(", ",,INDEX(TEXTSPLIT(TEXTBEFORE(A2, " -",-1)," "),,{2,1}))

 

[kmsprague]

Fluff, once again you've saved my day!! This worked perfectly! Thank you so very much!

 

[Fluff]

You're welcome & thanks for the feedback.