Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Any way to delete rows that don't contain 'x'?
Hi, I've exported a CSV list of phone calls from Skype into Excel. I want
to delete all rows that do not contain a certain number string e.g. 0000. Is this possible? Ideally it would move other rows up to fill the gaps so I'm just left with a neat list of remaining numbers. -- Thanks. CJSnet (Remove TEETH to reply by e-mail.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
Delete specified critria rows | Excel Discussion (Misc queries) | |||
delete repeating rows | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |