if cell CONTAINS xyz, then abc
 

I have a column that contains many values in text. I am searching this
column to see if it contains the partial text "Clinic". For example, three
cells could contain:

Physician, Administrator
Clinical Professional-Super
Office Staff-Clinical

I want to state, =if(cell B2 CONTAINS "*clin*", then "yes", else "") This
would give me a "yes" on the second two cells, but not the first.

How can I select just a few letters within a column to search on? I've
tried *Clin* and I get the else answer.

Thank-you for any help with this problem.

if cell CONTAINS xyz, then abc
 

=IF(NOT(ISERROR(SEARCH("clin",B2))),"YES","")

Dave
--
Brevity is the soul of wit.


"Kyli" wrote:

I have a column that contains many values in text. I am searching this
column to see if it contains the partial text "Clinic". For example, three
cells could contain:

Physician, Administrator
Clinical Professional-Super
Office Staff-Clinical

I want to state, =if(cell B2 CONTAINS "*clin*", then "yes", else "") This
would give me a "yes" on the second two cells, but not the first.

How can I select just a few letters within a column to search on? I've
tried *Clin* and I get the else answer.

Thank-you for any help with this problem.

if cell CONTAINS xyz, then abc
 

Thank-you, Dave. That worked perfectly.
Kyli

"Dave F" wrote:

=IF(NOT(ISERROR(SEARCH("clin",B2))),"YES","")

Dave
--
Brevity is the soul of wit.


"Kyli" wrote:

I have a column that contains many values in text. I am searching this
column to see if it contains the partial text "Clinic". For example, three
cells could contain:

Physician, Administrator
Clinical Professional-Super
Office Staff-Clinical

I want to state, =if(cell B2 CONTAINS "*clin*", then "yes", else "") This
would give me a "yes" on the second two cells, but not the first.

How can I select just a few letters within a column to search on? I've
tried *Clin* and I get the else answer.

Thank-you for any help with this problem.

if cell CONTAINS xyz, then abc
 

No problem.
--
Brevity is the soul of wit.


"Kyli" wrote:

Thank-you, Dave. That worked perfectly.
Kyli

"Dave F" wrote:

=IF(NOT(ISERROR(SEARCH("clin",B2))),"YES","")

Dave
--
Brevity is the soul of wit.


"Kyli" wrote:

I have a column that contains many values in text. I am searching this
column to see if it contains the partial text "Clinic". For example, three
cells could contain:

Physician, Administrator
Clinical Professional-Super
Office Staff-Clinical

I want to state, =if(cell B2 CONTAINS "*clin*", then "yes", else "") This
would give me a "yes" on the second two cells, but not the first.

How can I select just a few letters within a column to search on? I've
tried *Clin* and I get the else answer.

Thank-you for any help with this problem.

if cell CONTAINS xyz, then abc
 

=IF(ISNUMBER(SEARCH("clin",B3)),"yes","")

"Kyli" wrote:

I have a column that contains many values in text. I am searching this
column to see if it contains the partial text "Clinic". For example, three
cells could contain:

Physician, Administrator
Clinical Professional-Super
Office Staff-Clinical

I want to state, =if(cell B2 CONTAINS "*clin*", then "yes", else "") This
would give me a "yes" on the second two cells, but not the first.

How can I select just a few letters within a column to search on? I've
tried *Clin* and I get the else answer.

Thank-you for any help with this problem.