Delete row if blank in a column
 

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!

Delete row if blank in a column
 

AutoFilter, find blanks. then delete those rows.
--
Best Regards,

Luke M


"Outlook, eh?" wrote:

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!

Delete row if blank in a column
 

Select column C and F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 08:27:07 -0800, Outlook, eh?
wrote:

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!

Delete row if blank in a column
 

Eventhough I surely have blanks, it is saying "No Cells Found"...

"Gord Dibben" wrote:

Select column C and F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 08:27:07 -0800, Outlook, eh?
wrote:

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!

Delete row if blank in a column
 

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

On Fri, 7 Dec 2007 11:15:02 -0800, Outlook, eh?
wrote:

Eventhough I surely have blanks, it is saying "No Cells Found"...

"Gord Dibben" wrote:

Select column C and F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 08:27:07 -0800, Outlook, eh?
wrote:

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!

Delete row if blank in a column
 

Hi all

EasyFilter have also a option to delete cells with ""
http://www.rondebruin.nl/easyfilter.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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

On Fri, 7 Dec 2007 11:15:02 -0800, Outlook, eh?
wrote:

Eventhough I surely have blanks, it is saying "No Cells Found"...

"Gord Dibben" wrote:

Select column C and F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 08:27:07 -0800, Outlook, eh?
wrote:

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 Yes
Ringo
John Yes
George Yes

Thanks as always. You have saved my neck many times!