Un-Concatenate

[Hank24]

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.

 

[Bernard Liengme]

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

 

[Jacob Skaria]

Use Text-to-Columns. Refer the below link for help.

http://www.bettersolutions.com/excel/EWZ228/NM315128331.htm

If this post helps click Yes

 

[Ron Rosenfeld]

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