View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Landa Landa is offline
external usenet poster
 
Posts: 15
Default how to remove blank cells in excel

Thank you all for your generous help!

"Landa" wrote:

I have an excel table which contains hundreds of rows with variable columns
(e.g. row 1 has data in 5 cells, row 2 has data in 10 cells etc). There are
blank cells in some of the rows and they are not in a regular pattern. Is
there any way I can remove all those blank cells?

Thanks a lot in advance!