Help with Excel macro please

Hello,

I have a list of names in column A, most rows contain only 1 name.

However, there are also rows in column A that have multiple names separated by a space: "asmith bjohnston sstanley"

In these cases, I'd like to separate the names into their own rows, all in column A. So "asmith bjohnston sstanley" would become:

"asmith"
"bjohnston"
"sstanley"

Can anyone help me out?

Thanks
snej