| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| "Last Cell" to find last row, but can't delete blank rows | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Delete rows with "C" | Excel Discussion (Misc queries) | |||
Linear Mode
