Justin

How is the data laid out?

First of all.....are the addresses really in 200 columns?

How many rows? Or all one row?

Please provide more detail and perhaps a sample of your data.

Do not send a file, just copy a sample and paste into a post.

BTW....what is "rows to columns" that you tried? Text to Columns? Transpose?


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 12:11:05 -0700, 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.