Delete row if blank in a column

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

I was wondering what function I should use if one of the columns has a blank
in it.
In this case I want to get rid of the Ringo row (Go Figure).

A B C
Paul (e-mail address removed) Yes
Ringo (e-mail address removed)
John (e-mail address removed) Yes
George (e-mail address removed) Yes

Thanks as always. You have saved my neck many times!
 
Select column C and F5>Special>Blanks>OK

Edit>Delete>Entire Row


Gord Dibben MS Excel MVP
 
Then the cells are not blank.

Perhaps they look blank due to a formula that returns "" if no data?

Or you have a space or spaces in the cells that look blank?

Are there formulas?

If not, in a helper column enter =LEN(C1)

Copy down.

What results do you get for the "surely blank" cells.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX problem with cells of same value 2
Multiple text in range into single column 3
Deleting Characters 2
SUMPRODUCT, SUM(IF(...), or some combination? 2
Manipulating Text in Rows with COUNTA and CONCATENATE 2
how to count#cells w/= value in other column and not count blank c 4
Hide columns based on row values 2
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top