Removing Blank Cells - Not Working!

[J_MAW]

Hi,

I am trying to remove blank cells from an excel sheet. I have followed the steps, select data range, Go to Special, Select Blanks and I keep getting the message "No cells found".

The sheet in question has been copied from a sheet with formula's and pasted as values. Could this be why the function won't work?

Any help or alternative suggestions would be greatly appreciated.

Document Sample Data

Many thanks,

 

[Joe4]

The sheet in question has been copied from a sheet with formula's and pasted as values. Could this be why the function won't work?

Yep, that is precisely the reason! Formulas with return empty strings are not the same as "blanks" and won't get picked up.

One way would be to just loop through the range and check for a value of "".

 

[J_MAW]

Yep, that is precisely the reason! Formulas with return empty strings are not the same as "blanks" and won't get picked up.

One way would be to just loop through the range and check for a value of "".

Thanks for your reply.

I have done and find and replace of bank cells to "empty", then done a further find and replace of "empty" to blank.

Then I done "Go to Special", Delete, Shift Up.

And it worked!

Thanks again.

 

[Joe4]

Yep, that is another way you could do it!
Glad you found a workable solution!