SUBSTITUTE in other languages:

The German translation of the Excel function SUBSTITUTE is:

EnglishNederlands
SUBSTITUTE

Description

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.