Separating Name, Birthday, email, address, etc that is in one cell

[ABreyen]

Hello, I was wondering if it is possible to separate THIS into THIS. (Links to Google Drive)



in seprate columns automatically. I can copy/paste over and over again, but I have over 100 of these that I'd like done. Any ideas?

Office Mac 2011/2015

[macropod]

Sure, it's possible, and it's not very difficult to do, with splits at each space in the data and getting rid of the commas. However, the results are liable to give a column layout that's quite inconsistent as to which item ends up in what column.

For example, your sample has:

John Smith 10/7 email@example.com 12345 Anystreet Anytown, XX, 12345 (123) 456-7890

but what would you expect to happen if another row had:

John Malcolm De Walt 10/7 email@example.com Unit 35A 12345 Some otherstreet Rd My New Town, XX, 12345, Canada (123) 456-7890

In this case, you've got 9 additional spaces, some of which make meaningful delineations (e.g. 2nd given name, two-word surname, unit name & #, street type, country).