Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
i'm struggling to find a word in a specif text string, any ideas?
thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote:
i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Ron,
yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Specifically, what happened when you used Edit - Find? Exactly what did you
do when you used Edit - Find? Otto "jan" wrote in message ... Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
You are posting in programming group.
Do you want to use VBA to find the string? And what will you do with the result when you have found the string? Do you want to replace with another? Highlight the cell? Highlight the string within the sentence? Without programming.............................. EditFindWhat: not approved Make sure you don't have "match entire cell contents" enabled. Gord Dibben MS Excel MVP On Sat, 13 Sep 2008 11:51:01 -0700, jan wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Jan,
You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
=(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON
APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 "Otto Moehrbach" wrote: Specifically, what happened when you used Edit - Find? Exactly what did you do when you used Edit - Find? Otto "jan" wrote in message ... Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
your right.
=(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Here is another way for you to try...
=IF(D2="30000104",0,IF(COUNTIF(F2,"*travel*")+COUN TIF(F2,"*non approved*")0,0,H2/520)) -- Rick (MVP - Excel) "jan" wrote in message ... your right. =(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
i got it to work, the if tru/ not true where mixed up
=(IF(D4="30000104";0;IF(ISERROR(FIND("TRAVEL";F4)) ;IF(ISERROR(FIND("NON APPROVED";F4));H4/520;0);0))) "jan" wrote: your right. =(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Jan,
Note i've changed ; to , for my machine, change it back for yours =IF(D2=30000104,0,IF(AND(ISERROR(SEARCH("Travel",F 2)),ISERROR(SEARCH("Non Approved",F2))),H2/520,0)) Mike "jan" wrote: i got it to work, the if tru/ not true where mixed up =(IF(D4="30000104";0;IF(ISERROR(FIND("TRAVEL";F4)) ;IF(ISERROR(FIND("NON APPROVED";F4));H4/520;0);0))) "jan" wrote: your right. =(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
Forgot to mention I also took 30000104 out of quotes because I guess its a
number if its really text then put the quotes back Mike "Mike H" wrote: Jan, Note i've changed ; to , for my machine, change it back for yours =IF(D2=30000104,0,IF(AND(ISERROR(SEARCH("Travel",F 2)),ISERROR(SEARCH("Non Approved",F2))),H2/520,0)) Mike "jan" wrote: i got it to work, the if tru/ not true where mixed up =(IF(D4="30000104";0;IF(ISERROR(FIND("TRAVEL";F4)) ;IF(ISERROR(FIND("NON APPROVED";F4));H4/520;0);0))) "jan" wrote: your right. =(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify specific word in a range of words
thanks guy's, apprecite the help.
regards from the Netherlands "Rick Rothstein" wrote: Here is another way for you to try... =IF(D2="30000104",0,IF(COUNTIF(F2,"*travel*")+COUN TIF(F2,"*non approved*")0,0,H2/520)) -- Rick (MVP - Excel) "jan" wrote in message ... your right. =(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON APPROVED";F2;1));0;H2/520)))) F2 contains the text, if it either contains "travel" or "non approved" the output should be 0 if not the result must be H2/520 hope this helps "Mike H" wrote: Jan, You aren't being really clear about what you want. The finds the position of the first letter of the string in the sentence in a1 =SEARCH("non approved",A1) Having found that what do you want to do? Mike "jan" wrote: Ron, yes I tried to apply the standard functions but cannot solve it myself. i need to find the string "non approved" in a sentence. regards. "Ron Rosenfeld" wrote: On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote: i'm struggling to find a word in a specif text string, any ideas? thanks Did you try the FIND or SEARCH worksheet functions? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count 2 (Two) specific words in a cell in a given range | Excel Programming | |||
Count Specific word in Specific range | Excel Programming | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
search for a specific word and copy the word and the preceeding words until a comma | Excel Programming |