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.

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.