title: Excel - Find and replace multiple parts of formula simultaneously
body: <p>First post, please be kind :)</p>
  
  <p>I am updating a dataset by repeating calculations from a prior year (2015) onto the most recent year's data (2016). I have copied the old year's formulas into new columns, and I only have to change a few parts of each formula. </p>
  
  <p><em>Example</em></p>
  
  <blockquote>
    <p>2015 formula: =COUNTIFS(<strong>Data15</strong>[title], Datasheet!$B$2,
    <strong>Data15</strong>[variable<strong>2015</strong>], "variable", <strong>Data15</strong>[variable2<strong>2015</strong>], "&lt;=100")</p>
    
    <p>2016 formula: =COUNTIFS(<strong>Data16</strong>[title], Datasheet!$B$2,
    <strong>Data16</strong>[variable<strong>2016</strong>], "variable", <strong>Data16</strong>[variable2<strong>2016</strong>], "&lt;=100")</p>
  </blockquote>
  
  <p>I only have to change two parts of the formula: Data15 -> Data16, 2015 -> 2016. There are hundreds of these formulas to update, and I could manually go in and update these small parts of the formula. It is much faster to Find and Replace parts of the formula for all the formulas at the same time. However - to my knowledge - Find and Replace only allows you to replace one thing at a time (i.e., either Data15 -> Data16 OR 2015 -> 2016). I have tried to replace one and then replace the other, but the formula breaks unless both of them are replaced together. </p>
  
  <p><strong>The question: In Excel, is there a way to find and replace multiple parts of a formula simultaneously?</strong> Essentially, I would like to replace both Data15 -> Data16 and 2015 -> 2016 in the same Find and Replace, for a batch of cells. Is that possible? </p>
  
  <p>Thank you!</p>