Format Cell

[jtswanny]

Two part question:
How do I split cell that contains:
JON A *SWANSON into a 3 different cells that say Jon A Swanson. I need to change caps and split the name and also split the last name by the astrisk. Any suggestions. Hope this makes sense (here are some more examples) they always help).
DAVID *ADAMSON to David Adamson (two cells)
CHRIS *ALEXANDER to Chris Alexander
CHRIS *ALEXANDER to Chris Alexander
FANNY *ALLEN to Fanny Allen
JERRY *ANDERSON Jerry Anderson

 

[lenze]

Data>Text to Columns.

Choose "space" as the delimiter
Remove * with Replace if needed