I know there's an easy way to do this, but can't remember...

I want to copy data ie Mr John Bloggs into an excel sheet.

However, I want each name to be in a different cell, ie Mr in A1, John in B1
and Bloggs in C1

How do I do this?