How to find a particular work and give the comment in a different cell

  • Thread starter Thread starter Manu
  • Start date Start date
M

Manu

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.
 
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(SEARCH("script",A2))),"","Present")

Regards,
Stefi



„Manu†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically identify a particular formula (VLOOKUP) in a cell 0
Excel Import Comments 3
Code to add comments to selected cells within a selected range 30
find and scroll to cell string value in Excel 2
Working with Cell Comments - VBA 14
Search for a text in a cell and give the outcome later 3
Make Macro Work On A Different PC 5
check if a string contains a particular character 3

Back
Top