title: Find words and copy into next column in Excel
body: <p>I would like to find and copy text into next column in Excel. I have column A, with text or sentences. I want to find a particular word and copy that word into the next column that is column B only if that word is available in the text of Column A.</p>
  
  <p>I have this solution for single word search and copy but I want to apply this for multiple search and copy of different words: </p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("processes", A4)), MID(A4, SEARCH("processes", A4), 9), "")
  </code></pre>
  
  <p>Example: </p>
  
  <p>Suppose Column A contains text like this:</p>
  
  <pre><code>"Execution of procedure and processes".
  "All Procedures are correctly updated" 
  "Processes are going smoothly".
  </code></pre>
  
  <p>I want to search for word as <code>"Processes and procedure"</code> and that should copy in Column B (cell 1) "ONLY IF" either <code>processes</code> or <code>procedure</code> is in the text.</p>
  
  <p>Could you please help me out in this?</p>