View Single Post
 
Old 07-01-2015, 05:11 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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:
Code:
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:
Code:
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).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote