Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Un-Concatenate
I have a column of address information (Street City State Zip) each address
is contained in one cell. I need to seperate the information so that the Street is in its own cell, City is in another, and so on. I want to "Un-concatenate" the information. The information is seperated by spaces. nyone have any suggestions? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Un-Concatenate
Have a look at Data | Text-to-Columns
You might end up with Street No separated from Street Name but they could be re-concatenated The biggest problem with be Streets and Cities with multi-word names best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Hank24" wrote in message ... I have a column of address information (Street City State Zip) each address is contained in one cell. I need to seperate the information so that the Street is in its own cell, City is in another, and so on. I want to "Un-concatenate" the information. The information is seperated by spaces. nyone have any suggestions? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Un-Concatenate
Use Text-to-Columns. Refer the below link for help.
http://www.bettersolutions.com/excel...M315128331.htm If this post helps click Yes --------------- Jacob Skaria "Hank24" wrote: I have a column of address information (Street City State Zip) each address is contained in one cell. I need to seperate the information so that the Street is in its own cell, City is in another, and so on. I want to "Un-concatenate" the information. The information is seperated by spaces. nyone have any suggestions? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Un-Concatenate
On Tue, 23 Jun 2009 15:33:01 -0700, Hank24
wrote: I have a column of address information (Street City State Zip) each address is contained in one cell. I need to seperate the information so that the Street is in its own cell, City is in another, and so on. I want to "Un-concatenate" the information. The information is seperated by spaces. nyone have any suggestions? Thank you. If they are truly separated only by spaces, then you will have a problem with multiword streets and cities (and states unless they are all the two-letter abbreviations). Give some examples. It may be that a zip code lookup to determine the actual city and state may be the way to go. How long is your list and how often do you need to go through this process? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
concatenate | Excel Discussion (Misc queries) | |||
Concatenate | New Users to Excel | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Un-concatenate | Excel Discussion (Misc queries) |