=MID(A2& " " & A2,FIND(" ",A2)+1,LEN(A2)+1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jamie G." wrote in message
...
I have a large list of people who are listed Last name first in a cell. I
want to show the names in that cell to be First Name & then Last name.
How
can I accomplish this?

Thanks

Jamei