Hi BABYPINK

Is all the information in one cell ?
Or is RAL9001 in a seperate cell


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"BABYPINK" wrote in message ...
Hi

I have a smallish table that lists Parts, and I only want to list the parts
that have RAL9007, RAL9005, RAL9006, each row looks something like this with
various combinations

ADJ SNACK FLANGLE SHELF 400MMDEEP 1250MM CREAM RAL9001 +SEL

I have 16,000 rows of these and it will take me ages to delete the rows out
I do not want, any idea what formula I would need

Thanks