I tried this too, and a customer angrily asked why they can't sort their report alphabetically by last name. Sigh.
Split on the space and take everything after the first space as the last name. Oh wait, some people have multiple first names.
Merging names is a one-way door, you can't break them apart programmatically. Knowing this, I put a lot of thought into whether it was worth it to merge them.