Finding a specific text in a cell

[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

 

[Lars-Åke Aspelin]

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

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

 

[slah]

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 -

Thanks. that helped

shriil