Do you use commas or spaces to separate the items? Are some of the form 40
Brown Street and others of the form 40 John Brown Street? It might be more
convenient to do the change via Word. Could you provide 2 or 3 examples?

"Justin" wrote:

I have 200 columns containing partial addresses (number, street & city). How
do I seperate each into int's own field. (I've tried 'rows to columns' with
no success.