Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Address Formatting
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validating email address formatting | Excel Worksheet Functions | |||
e-mail address formatting | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
How to apply conditional formatting with incremental address for . | Excel Worksheet Functions |