Content

[lightbulb]

If I'm in cell C5, I want a formula that will do the following; if cell B5
contains "Assembly" anywhere in it's text, then I want C5 to say Assembly,
otherwise I want C5 to copy B5.

Any help?

 

[David Biddulph]

=IF(ISNUMBER(SEARCH("Assembly",B5)),"Assembly",B5)

 

[Dave Peterson]

Check your other post.

If I'm in cell C5, I want a formula that will do the following; if cell B5
contains "Assembly" anywhere in it's text, then I want C5 to say Assembly,
otherwise I want C5 to copy B5.

Any help?