Mid

Syntax

Mid(Text, Start_num, Num_chars)

Text. Source string, from which you want to get a substring.

Start_num. Starting substring position in the source string.

Num_chars. Number of substring characters to be obtained from source string.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns a substring from a specified string based on starting position and length.

Numbering of elements in the source string starts with zero.

Formula	Result	Description
=Mid("qwerty", 3, 2)	rt	Two characters from the "qwerty" string starting from the third one.
=Mid(B6, 0, 3)	asd	A substring containing three characters from the beginning of the source string. The source string is located in the B6 cell. The B6 cell contains the asdfgh value.