View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default I need to clean a database

I have rows without any data in them throughout my database. Can I do a
simple function to delete the empty rows between my data to clean up my list
in excel.

Second question, on the same database I have an column that consists of name
address city and zip. Is there a way to run a formula to separate these
values into their own rows.