Most valuable professional
  • Hot Topics

Excel CONCATENATE search question

Hello all, I am trying to create a Concatenate formula that searches a cell for "PHRASE" or "PHRASE 2". If either phrase exist than the output is 43. Can someone show me what this formula would look like? It cant be two different if statements like Code: This will give me 43,43 I am looking for something like Code: =CONCATENATE(IF(ISNUMBER(SEARCH("PHRASE" Is this possible?

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of June 20, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel