<div>
Press Ctrl + H and then do as shown below.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/02_w09/900339/excelreplace.png" target="_blank" title="excel (6 KB)"><img alt="excel" class="file-block lazyload" style="max-width: 464px;" data-src="https://filedb.experts-exchange.com/incoming/2015/02_w09/900339/excelreplace.png" /></a>
</div>


Press Ctrl + H and then do as shown below.

excelhttps://filedb.experts-exchange.com/incoming/2015/02_w09/900339/excelreplace.png

excelreplace.png

<div>
or you can use <br />
<br />
<br />
=REPLACE(A1,3,1,5)
</div>


<div>
<div class="content wysiwyg-content">
I have several columns similar to this-<br />
#C5*C8<br />
#C6*C9<br />
#C7*C10<br />
(continues all the way to #C26*C28)<br />
<br />
And it should be this (C5 is constant)-<br />
#C5*C8<br />
#C5*C9<br />
#C5*C10<br />
(continues all the way to #C5*C28)<br />
<br />
I need a formula that I can apply and come up with the desired results. Thanks.
</div>
</div>


I have several columns similar to this-
#C5*C8
#C6*C9
#C7*C10
(continues all the way to #C26*C28)

And it should be this (C5 is constant)-
#C5*C8
#C5*C9
#C5*C10
(continues all the way to #C5*C28)

I need a formula that I can apply and come up with the desired results. Thanks.

Excel replace formula?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.