Substitute Function to Replace Value
SUBSTITUTE function is used to replace occurrences of a specified substring with another substring in a given text string. The syntax for the SUBSTITUTE function is as follows:
excel
Copy code
=SUBSTITUTE(text, old_text, new_text, [instance_num])