Excel MID Function: How to Use It, with Examples
Turkish: PARÇAAL

Returns characters from the middle of a text, starting at a position you choose.

MID syntax

=MID(text, start_num, num_chars)

In Turkish Excel: =PARÇAAL(metin; başlangıç_sayısı; sayı_karakterler)

ArgumentDescription
textThe text.
start_numPosition of the first character.
num_charsNumber of characters.

MID examples

Sample table:

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

Takes the year (4 characters from position 4) from the code.

Results were calculated in real Excel.

Related functions

More formula guides

More tools

About MID Function

Returns characters from the middle of a text, starting at a position you choose.

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 MID Function

  1. Type the formulaStart typing =MID( 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 MID in Turkish Excel?

In Turkish Excel, MID is called PARÇAAL. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have MID?

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