Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Blank Lines | Excel Discussion (Misc queries) | |||
I cannot delete a blank column from an Excel spreadsheet. | Excel Discussion (Misc queries) | |||
Delete a row if blank cell | Excel Discussion (Misc queries) | |||
Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
"BLANK" - need to delete | Excel Worksheet Functions |