SEARCH WORKSHEET USING A NOT CRITERIA

[lghovden06]

I'm updating a new price sheet for a business from the new prices online. On
the new sheet from the internet there are bulk, 55 GA drums, 12/1 packages
and so on. I only need the prices for everything but the bulk. Each product
is listed like this
Ursa 15/40
Ursa 15/40 (55GA NRD)
Ursa 15/40 (12/1-GT)
Ursa 15/40 (5Ga Pal)
Rando 68....
So the Ursa 15/40 and Rando 68 I don't need. There are about 4,000
products, so to go through and delete them one at a time is time consuming.
I tried to search, but I can't search for NOT something ex :
Find: NOT: "*(55GA NRD)" I believe the * will search for any string of
characters before (55GA NRD).
Then I tried to insert a new column and do a conditional formula.
ex: =NOT(E5= "*(55GA NRD)")
However this did not work either. Can any one help solve my problem.
THANK YOU

 

[Pete_UK]

Is the example data housed in one column, with the price information
in another? Will the bulk item description always be shorter than the
other descriptions, as in your example? Are the words before the first
space unique? (i.e. could you have Rando 97, or Ursa 18/30 for
example?)

Pete

 

[lghovden06]

Yes the example data is housed in one column and the prices in another and
yes the bulk items will always be shorter in that product. I do not believe
the words before are unique. (i.e. there is Rando 32, Rando 46, and Rando
68. there is also Ursa 5/30, Ursa 10/30, Ursa 15/40 and so on)