The SUBSTITUTE function in Excel is used to replace existing text with new text in a string, allowing you to target specific occurrences of a substring. Unlike REPLACE, which works based on position, SUBSTITUTE identifies exact text to change—making it ideal for cleaning and restructuring textual data.