On Sat, 5 Jun 2010 22:07:18 +0100, Colin Hayes wrote:
I need to say this :

IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2 =11 THEN PUT 1 ,

Then why don't you read the numerous responses that were posted in
microsoft.public.excel.misc (including one from me)?

Please do not post the same question multiple times.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...