View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Deleting blank cells AFTER an UNMERGE

F5SpecialBlanksOK

EditDelete.........shift up or left


Gord Dibben MS Excel MVP

On Fri, 25 Apr 2008 11:50:03 -0700, Troy wrote:

Hello,

Is there a less labor intensive way to delete scattered blank cells as a
result of doing an unmerge?

My thanks,

Troy