Excel Function LastName,(Space)First Name

[JimStrand]

I have an excel function which converts cell A1 from First Last to Last,First.
A1 C1
FirstName LastName LastName,FirstName

Formula in C1
=MID(A1&","&A1,FIND(" ",A1)+1,LEN(A1))

What I need is a space before the FirstName

Any suggestions for revising the function to obtain this result? Many Thanks.

Jim

 

[TonHu]

This is an Exchange forum, not Excel, sorry.