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

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.

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