Thanks so much - but for some reason, it's not recognizing that there are any
blanks. My dataset is a copy/paste value from another tab that contains
formulas. The formulas say ="" if criteria is not met. Those end up being my
blank cells. I've tried changing the format. Any help would be appreciated.
Thanks

"Gord Dibben" wrote:

Select the range and F5SpecialBlanksOK

EditDeleteShift Up or Left whichever you choose.

Probably up, looking at your example, but xxxxx doesn't give a good read on
values.

Might be an idea to do this on a copy of the worksheet.


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 15:29:01 -0800, Alina
wrote:

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