code to find text and insert

Hi Guys

I have a range lets say A1:A1000 with a product description in each cell. I need acode that will look through those cells and if any of them contain the word 'hello' then the word 'goodbye' would be put into the next cell.

For example if A1 had 'hello my name is simon' in it then after the code had run the word 'goodbye would appear in B1.

Any help would be much appreciated.

Here, try this:

=IF(ISERR(FIND("hello",A1)),"","goodbye")

However, this would also write you "goodbye" if your A cell has word violonchello (I know it's violoncello but need to change it for purpose of example ).

Or do you need to ignore that words?

Also, FIND is case sensitive. If you don't want case sensitive you need:

=IF(ISERR(SEARCH("hello",A1)),"","goodbye")

If you don't mind a macro, this demo might be of interest.

awsome, thanks for the replies. Yes the macro works perfectly for what I need.

Hi twofootgiant

Glad to have helped.

Please feel free to ask anything you need explaining.

Regards
Alistair

However.

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.