| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if text string
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"). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if text string
Nigel,
Try: =IF(ISNUMBER(SEARCH("Nurse",A2)),"Nurse Activity","Consultant Activity") HTH "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"). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if text string
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"). |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if text string
many thanks - it worked, saved me a lot of time.
"Toppers" wrote: Nigel, Try: =IF(ISNUMBER(SEARCH("Nurse",A2)),"Nurse Activity","Consultant Activity") HTH "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"). |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Linear Mode
