Go to blanks in a range to remove the blank cells

[already]

Hello,

I'm trying to remove the blank cells in a range of cells.

But if I doing find > Go to special blanks the result is "no cells were found" but the cells are really empty.

The goal is to remove those blank cells after selection and doing a shift up.

In the range the cells that I want to remove are only rows.

Any help is welcome

Kind regards

Al

 

[CalcSux78]

Would identifying the range and sorting be what you're looking for? If you can post a sample of what your sheet layout, it would be easier to help you find a solution.

 

[Jonmo1]

But if I doing find > Go to special blanks the result is "no cells were found" but the cells are really empty.

I would suspect that those cells are the result of a formula returning ""
"" is NOT blank, it's a TEXT value.
Even if that formula has since been copied and pasted as values.

Maybe let that formula return someting else, like an error value NA()
Then you can use the special - errors

 

[already]

Thanks for your reply CalcSux78 and Jonmo1,

Jonmo1 you are right its the result from past as values. It's a nice work around to return something else instead of blanks.

Kind regards

Al

 

[Jonmo1]

You're welcome