Finding a specific text in a cell

  • Thread starter Thread starter shriil
  • Start date Start date
S

shriil

Hi

I have a column which has remarks stored in each row, e.g.

Col A
'may be awarded on manpower rates'
'can be awarded on general quotation Ref No. XXX'
'has carried out the job on basis of general quotation'

For Column B, I would like to search the word "general" in Column A,
and if found then the value in Column B will be "YES" and if not "NO".

How do I go about it? Thanks for the help


shriil
 
Hi

I have a column which has remarks stored in each row, e.g.

Col A
'may be awarded on manpower rates'
'can be awarded on general quotation Ref No. XXX'
'has carried out the job on basis of general quotation'

For Column B, I would like to search the word "general" in Column A,
and if found then the value in Column B will be "YES" and if not "NO".

How do I go about it? Thanks for the help


shriil
Click to expand...


Try this formula in cell B1 and copy down as far as needed:

=IF(ISERROR(FIND("general",A1)),"NO","YES")

If you don't care about lower/upper case letter you can use SEARCH
instead of FIND.

Hope this helps / Lars-Åke
 
Try this formula in cell B1 and copy down as far as needed:

=IF(ISERROR(FIND("general",A1)),"NO","YES")

If you don't care about lower/upper case letter you can use SEARCH
instead of FIND.

Hope this helps / Lars-Åke- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks. that helped

shriil
 
Back
Top