ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to delete rows with "-" in cell (https://www.excelbanter.com/excel-discussion-misc-queries/256528-how-delete-rows-cell.html)

RS

How to delete rows with "-" in cell
 
How do I delete rows that contain the hyphen (-) symbol in them? Also, I
tried using the F5, special, blanks feature to delete blank rows, but it says
that my selection is too large. Is there a limit to the number of rows that
you can select? I am assuming yes as it seems to be limiting me in the
amount of rows I can select.

As always, I appreciate the input of all the experts here!


All times are GMT +1. The time now is 06:09 PM.

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