As long as you are sure that it is only first and lastname in the data the use CHARINDEX to find ' '. Once you know the position of the ' ' you can manipulate any way you want.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)