Description

MID is a text function in Excel. Having three arguments, all are mandatory. First is text the text string from which you want to extract the character(s). Second is start_num, the specific position to start and the last is num_chars, number of character(s) you want to extract

Syntax

MID(text, start_num, num_chars)

Example

MID Excel function returns the specified number of characters from a given text string from a specified position
If start_num is greater then length of the string, MID returns empty string
If start_num is 0 or negative MID returns #VALUE! Error

0 Comments

By Rajesh K Saraogi

Rajesh is a hardcore finance person with a penchant for latest technology. His passions are latest technology and to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!

Text Functions