View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alina Alina is offline
external usenet poster
 
Posts: 6
Default delete blanks - sporadic

My dataset is from A2:G56. Each column has a different header. I have
sporadic blank cells throughout the dataset and want to delete them. How do I
delete the blank cells? See sample below: Thanks in advance :)

Principle Interest Fee1 Fee2 Disbursement
xxxx xxxxx xxxxx
xxxxx xxxxxx
xxxx