View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jayceejay jayceejay is offline
external usenet poster
 
Posts: 24
Default Breaking up a string

I have an "Address" field in Excel that houses Street address, City, State, &
Zip, separated only by spaces. How do I go about separating strings into New
fields for City, State, and Zip? Is there some kind of VBA code I can use to
separate the larger string?