if text string
many thanks, it worked
"RichardSchollar" wrote:
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
On 15 Mar, 11:15, Nigel wrote:
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").
|