title: Excel 2010: How can I change formulas across multiple cells without modifying their input values?
body: <p>I would like to bulk-change formulas across multiple cells without altering the input value. Is there a way to make this change without going cell by cell, or creating a macro to go cell by cell, and manually replacing the formula type?</p>
  
  <p>When I say input values, I mean the contents of the parenthesis, following a given formula; which, in this case, is the "(number, significance)" values which are specific to each cell.</p>
  
  <p>For example:</p>
  
  <p>I have a column of cells which contain something like the following,</p>
  
  <ul>
  <li>In D40, we have =ROUNDUP(197.3+14.84+109.09+12.18+12.18, 5);</li>
  <li>In D47, we have =MROUND(85.16+40+24+47+24+19+9+8, 5);</li>
  <li>And so on, for an entire column with hundreds of cells</li>
  </ul>
  
  <p>I want to change every function within those cells to =CEILING without changing the inputs, so that</p>
  
  <ul>
  <li>D40 would change to =CEILING(197.3+14.84+109.09+12.18+12.18, 5);</li>
  <li>D47 would change to =CEILING(85.16+40+24+47+24+19+9+8, 5);</li>
  <li>And so on for every cell</li>
  </ul>
  
  <hr>
  
  <p>Specific Considerations:</p>
  
  <ul>
  <li><p>I am not familiar with macros, and I won't be surprised if there is no alternative means to automate the changes;</p></li>
  <li><p>I am using Excel 2010, MSFT Office Pro;</p></li>
  <li><p>The spreadsheet is a quantity takeoff, where all values within the parenthesis of each cell's formula are input manually and reflect different linear foot values from architectural plans;</p></li>
  <li><p>The group of cells I want to change are all contained in the same column;</p></li>
  <li><p>The CURRENT formula (the one I want to replace) is the same for every cell, and it is =ROUNDUP;</p></li>
  <li><p>The PROPOSED formula (the one I want to replace the current formula) is the same, and I want it to be =CEILING; and</p></li>
  <li><p>I REQUIRE that the contents of the parenthesis remain unchanged.</p></li>
  </ul>
  
  <hr>
  
  <p>I've tried to make sure this is not a duplicate question, but my apologies if I just didn't find the original. Thank you for your help!</p>