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