Removing blank spaces with formatting

[Andy0311]

Hello,

I am trying to remove blank spaces and blank spaces with formatting from a long column of letters. Here is a an example: When I do a Find and Replace Blanks, rows 11-13 will be highlighted, but when I go to Delete Sheet rows, only rows 11-12 will be deleted. How can I delete row 13? Thanks for your help.

 

[alansidman]

Without seeing your actual data, I am only guessing as to the issue. Because Row 13 is colored, there is formatting and as such it is not technically blank.

 

[Andy0311]

Without seeing your actual data, I am only guessing as to the issue. Because Row 13 is colored, there is formatting and as such it is not technically blank.

It is formatting. The partial column I included was cut and pasted from a much larger data set, which was divided into sections. The space between the sections was formatted. Thanks again.

 

[Peter_SSs]

If there is nothing in those cells except formatting then the following should remove them
Select the column -> F5->Special...->Blanks->OK->Delete Sheet Rows

If that does not delete them appropriately then there must be something else going on in your worksheet that we cannot see from an image and we would need to access some actual sample data (eg with XL2BB as a starting point)