MID Function or MID Formula in Excel with example

MID Function or MID Formula in Excel with example

MID

Returns character(s) from a string based on starting index and length. In other words MID function offers a character(s) extraction method based on inputs. We will understand MID Function in detail with example as part of this article.

Syntax

=MID(text, start_num, num_chars)

Parameters

  1. text: a mandatory parameter, refers to a string or text from which characters needs to be extracted.
  2. start_num: a mandatory parameter, refers to starting point from which characters needs to be extracted. Should be a positive number.
  3. num_chars: a mandatory parameter, refers to number of characters need to be extracted from input string. It should be an integer and should not be greater than input text.

Formula example

Output

Notice the first formula where we are extracting 10 characters from input string starting from 1st character resulting “VBAOVERALL“. In second formula we are extracting starting from 11th character rest of the string by using LEN function.

Next >> BASE Function in Excel with example

Leave a Reply

Your email address will not be published.