Paste across multiple columns

[PMM123]

How do I take data and paste it across multiple columns using the spaces.  Example: Joe Bloggs 23 UK.  I'd like to paste Joe into column 1, Bloggs into column 2, 23 into 3 etc for Joe and all the subsequent people?

Thanks a lot

[#2]

@PMM123 On the Data ribbon, you'll find an icon called "Text To Columns". Click and follow the instructions, using a space as the delimiter.