How to Use Excel MID Function (Examples + Video)

Excel MID Function (Example + Video)

Excel MID Function

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:

You may also like the following Excel tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

1 thought on “How to Use Excel MID Function (Examples + Video)”

Leave a Comment