ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete rows with empty cells in columns B&C (https://www.excelbanter.com/excel-discussion-misc-queries/78094-delete-rows-empty-cells-columns-b-c.html)

Richard

Delete rows with empty cells in columns B&C
 
Hi,

I have a huge spreadsheet that needs to have all rows with empty cells in
both columns B and C deleted. I was going through it line by line, but there
has got to be a better way. My knowledge of Excel and all of its features is
very limited. Any help would be appreciated.

Thank You,
Richard

CLR

Delete rows with empty cells in columns B&C
 
This is one of the standard features of ASAP Utilities, available at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Richard" wrote:

Hi,

I have a huge spreadsheet that needs to have all rows with empty cells in
both columns B and C deleted. I was going through it line by line, but there
has got to be a better way. My knowledge of Excel and all of its features is
very limited. Any help would be appreciated.

Thank You,
Richard


Richard

Delete rows with empty cells in columns B&C
 
Do I have to pay for these utilities?

"CLR" wrote:

This is one of the standard features of ASAP Utilities, available at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Richard" wrote:

Hi,

I have a huge spreadsheet that needs to have all rows with empty cells in
both columns B and C deleted. I was going through it line by line, but there
has got to be a better way. My knowledge of Excel and all of its features is
very limited. Any help would be appreciated.

Thank You,
Richard


CLR

Delete rows with empty cells in columns B&C
 
No, ASAP Utilities are free, sorry I forgot to mention that fact in my
post.....

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote in message
...
Do I have to pay for these utilities?

"CLR" wrote:

This is one of the standard features of ASAP Utilities, available at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Richard" wrote:

Hi,

I have a huge spreadsheet that needs to have all rows with empty cells

in
both columns B and C deleted. I was going through it line by line, but

there
has got to be a better way. My knowledge of Excel and all of its

features is
very limited. Any help would be appreciated.

Thank You,
Richard





All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com