Deleting blank cells AFTER an UNMERGE

[Troy]

Hello,

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

My thanks,

Troy

 

[Gord Dibben]

F5>Special>Blanks>OK

Edit>Delete.........shift up or left


Gord Dibben MS Excel MVP