How to Use Excel MID Function (Examples + Video)

Excel MID Function (Example + Video)

When to use Excel MID Function

MID function can be used to extract a specified number of characters from a string.

What it Returns

It returns the sub-string from a string.

Syntax

=MID(text, start_num, num_chars)

Input Arguments

• text – the text from which you want to extract the string.
• start_num – the starting position within the text argument, from where the extraction should begin.
• num_chars – the total number of characters that you want to extract.

Additional Notes

• Spaces are counted as characters.
  • To remove extra spaces, use TRIM function.
• If the start number is greater than the length of the text, MID returns “” (empty text).
• Returns an error if:
  • The start number is less than 1.
  • The number of characters is a negative number.

Excel MID Function – Live Example

Excel MID Function – Video Tutorial

Related Excel Functions:

• Excel CONCATENATE Function.
• Excel LEFT Function.
• Excel LEN Function.
• Excel REPT Function.
• Excel RIGHT Function.
• Excel TEXT Function.
• Excel TRIM Function.

You may also like the following Excel tutorials:

• Split Names in Excel (Using Formulas)