⌨ Syntax
MID(text,start_num,num_chars)
Arguments
text
(required)
— The text string containing the characters you want to extract.
start_num
(required)
— The position of the first character you want to extract in text. The first character in text has start_num 1, and so on. If start_num is greater than the length of text, MID returns "" (empty text). If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text. If start_num is less than 1, MID returns the #VALUE! error value.
num_chars
(required)
— Specifies the number of characters you want MID to return from text.