Thread: Un-Concatenate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hank24 Hank24 is offline
external usenet poster
 
Posts: 2
Default Un-Concatenate

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.