Forum Discussion
Paste across multiple columns
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
1 Reply
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.
