if text string

N

Nigel

please could someone assist.

I'm looking to summarize a field, in Excel, which contains text.

The field contains text and I won't to look via an if statement for the
incidents of one particular word in the text string -something along the
lines of =if(a2 =*Nurse*,"Nurse Activity","Consultant Activity").
 
T

Toppers

Nigel,
Try:

=IF(ISNUMBER(SEARCH("Nurse",A2)),"Nurse Activity","Consultant Activity")

HTH
 
R

RichardSchollar

Hi Nigel

Something like:

=IF(ISNUMBER(SEARCH("Nurse",A1)),"Nurse Activity",""Consultant
Activity")

or = IF(COUNTIF(A1:A1,"*Nurse*"),"Nurse Activity",""Consultant
Activity")

Hope this helps!

Richard
 
N

Nigel

many thanks, it worked

RichardSchollar said:
Hi Nigel

Something like:

=IF(ISNUMBER(SEARCH("Nurse",A1)),"Nurse Activity",""Consultant
Activity")

or = IF(COUNTIF(A1:A1,"*Nurse*"),"Nurse Activity",""Consultant
Activity")

Hope this helps!

Richard
Click to expand...
 
Top