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.