Funny Susan, I just asked this in another thread. Highlite the column then
Try "Data" "Text to Columns" and follow the prompts.

"Susan" wrote:

Can someone please tell me a formula that will split last names, first names
and middle initial or middle name in that order within a cell. No commas or
periods are used.

Susan