Un-Concatenate

  • Thread starter Thread starter Hank24
  • Start date Start date
H

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.
 
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
 
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.
Click to expand...

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
 
Back
Top