Deleting Rows With Criteria

[Bob Beard]

Hi there,

I have data in columns A to BS [numeric and words]

I want to delete all rows that do not contain the word
Stoke from column K.

The word Stoke may be on it's own or in a sentence [of no
more than 5 words].

Any suggestions,

Thanks,

Bob

 

[Jim Rech]

I'd suggest using Data, Filter, Advanced Filter to create a new list of just
the stoke rows. In the Criteria box point to a range off somewhere (that
you create) that has the same header label as column K and in the cell below
this: *stoke*

--
Jim Rech
Excel MVP
| Hi there,
|
| I have data in columns A to BS [numeric and words]
|
| I want to delete all rows that do not contain the word
| Stoke from column K.
|
| The word Stoke may be on it's own or in a sentence [of no
| more than 5 words].
|
| Any suggestions,
|
| Thanks,
|
| Bob

 

[Frank Kabel]

Hi
also see:
http://www.xldynamic.com/source/xld.Deleting.html