hello i have a simple question i hope somebody can help me out.

i have a long list of first name and last name in the same cell and the order of it is first name and afterwards last name.
i was wondering if there is a formula of some sort that will change the position of the text inside the cell so it will be last name then first name instead.

i hope i have made myself clear enough.

thanks for the support.
Amir