Excel SUBSTITUTE Function: How to Use It, with Examples
Turkish: YERİNEKOY

Replaces specific text in a string with other text.

SUBSTITUTE syntax

=SUBSTITUTE(text, old_text, new_text, [instance_num])

In Turkish Excel: =YERİNEKOY(metin; eski_metin; yeni_metin; [yineleme_sayısı])

ArgumentDescription
textThe text.
old_textThe text to replace.
new_textThe replacement.
[instance_num]Which occurrence to replace.

SUBSTITUTE examples

Sample table:

ABC
1Full nameEmailCode
2ayşe yılmazayse@ornek.comTR-2026-001
3 Mehmet Demir mehmet@ornek.comTR-2026-042
=SUBSTITUTE(C2,"-","/")
Result: TR/2026/001

Replaces the dashes in the code with slashes.

Results were calculated in real Excel.

Related functions

More formula guides

More tools

About SUBSTITUTE Function

Replaces specific text in a string with other text.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use SUBSTITUTE Function

  1. Type the formulaStart typing =SUBSTITUTE( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is SUBSTITUTE in Turkish Excel?

In Turkish Excel, SUBSTITUTE is called YERİNEKOY. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have SUBSTITUTE?

SUBSTITUTE is available in all current Excel versions (2010 and later, Microsoft 365).