View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TXDalessandros TXDalessandros is offline
external usenet poster
 
Posts: 24
Default Split address in 1 cell into 4

I have a extract from the web that puts the address field all in one and I
need to split this by street address then city state and zip into the next 3
columns. My data looks like this when extracted. There is a Square for the
implied enter after the end of the street address

1107 Hendrick Dr Suite B
Carbondale, CO, 81623

Is there code that could be used to split this from say column F into F, G,
H and I?

Thank you
Holly