Biweekly payroll calendar excelOct 16, 2015 · Using Excel REPLACE function with numeric values. The REPLACE function in Excel is designed to work with text strings. Of course, you can use it to replace numeric characters that are part of a text string, for example: =REPLACE(A2, 7, 4, "2016") Notice that we enclose "2016" in double quotes as you usually do with text values. Solving equations guided notesTable of contents Converting formulas to values using Excel shortcuts Replacing formulas with values in a couple of mouse clicks Excel formulas cannot put a value into other cells, only in the cell where a formula is entered.