Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular work and give the comment in a different cell
Hi
I have a sheet containing 1500+ lines. I need to find a particulart work "execute" or "script" from a cell which contains a big string which is entered by users. I need to check whether that particular work is there in that string and if its there i need to mention "Present" in a different cell. Can some one help me in solving this. I tried the built in functions but was not able to get the correct result. If some one can give me a VBA code for this it will be really helpful. regards Manoj S. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find a particular work and give the comment in a different
Hi Manu,
Assume column A contains words "execute" and"script", and you want "Present" to appear in column B, then type in B2 the following formula, and fill it down to 1500+ as needed: =IF(AND(ISERROR(SEARCH("execute",A2)),ISERROR(SEAR CH("script",A2))),"","Present") Regards, Stefi €˛Manu€¯ ezt Ć*rta: Hi I have a sheet containing 1500+ lines. I need to find a particulart work "execute" or "script" from a cell which contains a big string which is entered by users. I need to check whether that particular work is there in that string and if its there i need to mention "Present" in a different cell. Can some one help me in solving this. I tried the built in functions but was not able to get the correct result. If some one can give me a VBA code for this it will be really helpful. regards Manoj S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do gettinf certified give you a edge in the work place? | Excel Discussion (Misc queries) | |||
Can a formula find a comment in a cell | Excel Worksheet Functions | |||
Find comment replace cell value | Excel Discussion (Misc queries) | |||
In excel my find a value in a cell won't work. Why? | Excel Worksheet Functions | |||
Find cell of equal value of a range and give result of ajoining co | Excel Programming |