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.