MS Excel help

[wickedDUDE]

Hello,

I have 4000+ rows in excel and hundreds of rows contain a specific value in them. I want to remove all rows that have any instance of "/directory/"

How can I do this in Excel ?? I have the 2007 version if it helps.

Thanks!

 

[amateursurgeon]

Use a filter to only show anything that contains the string "/directory/", then just delete the stuff that's showing.

 

[omgyams]

This will return a true/false statement if /directory/ is in A1:

=ISNUMBER(SEARCH("/directory/",A1))

Pop this into a column, edit the A1 to reflect the column your data is in, then sort by true/false when done. Probably a smarter way to do it, but I use this formula for a lot of useful purposes.

 

[lukep]

Fuck me... I thought I'd logged onto Wickedfire, not the Microsoft help forums!

I gotta get my keyboard fixed or something...

 

[AMagz]

Select Column > Sort & Filter > Filter > Text Filters > Contains > /directory/ ---> delete all these cells.

Now, to get rid of the blank rows/cells...

Select Column > Find & Select > Go To Special > Blanks > OK > Delete > Delete Cells

 

[shawnhag]

keep it real simple

perhaps...find/replace

find "/directory/"
replace ""

 

[PhillipMarlow]

keep it real simple

perhaps...find/replace

find "/directory/"
replace ""

This. Yahoo answers has some spreadsheet ninjas that seem to lurk there on the regular, btw. I've had good luck asking questions there.

 

[CLKeenan]

I came here looking for a cool, challenging excel problem. Instead I found a question that is easily solved using the most basic of all features (filter -> contains '/directory/' -> delete all rows). Disappointed.

 

[Hav3n]

letmegooglethatforyou