SQL in Excel

[Jonathan]

Hi Everyone,

I want to know is this is possible......

In SQL views I can write code that uses the "CONTAINS" functions which
allows me to filter data in a less strict way that using mathematical
functions such as >= or = etc.

What I want to know is how do I use "CONTAINS" in an excel IF statement i.e.
if A1 CONTAINS 'BECK' then B12 = Beckingham etc.

Can I use CONTAINS & if so what is the systanx equivelant in Excel?

Tia


Jonathan

 

[VManes]

how about something along the lines of:

=IF(FIND("bob",A3), "Bobby")


Val

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
www.sdsmt.edu
The best little engineering school you
may not have heard of, but should have!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi Everyone,

I want to know is this is possible......

In SQL views I can write code that uses the "CONTAINS" functions which
allows me to filter data in a less strict way that using mathematical
functions such as >= or = etc.

What I want to know is how do I use "CONTAINS" in an excel IF statement i.e.
if A1 CONTAINS 'BECK' then B12 = Beckingham etc.

Can I use CONTAINS & if so what is the systanx equivelant in Excel?

Tia


Jonathan