View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puddgyballerina puddgyballerina is offline
external usenet poster
 
Posts: 1
Default address1, address2, city, state, zip in one cell; need in 5 cells

I have imported a spreadsheet in which address1, address2, city, state and
zip are all in one cell. Is it possible to use a formula, formulas or
processes to relatively easily place the data into separate cells? It's over
20,000 lines of data and we need it in separate columns to upload into our
sales database.