New_text: The text that will replace the characters in the old_ text. How to use the Substitute function in Excel Open Microsoft Excel. Create a table or use an existing table.

The Excel function SUBSTITUTE can replace symbols, numbers, or text. We explain how to use SUBSTITUTE function in Excel effectively.

While Excel's Find and Replace feature can handle this, the SUBSTITUTE function makes the process quicker and more efficient.