MID Function in Excel – Extract Substring in Excel

MID Function in Excel Extracts the substring from the given string. MID Function takes the String, the start of the string and length as an argument to return the substring.

Substring using MID Function in Excel – Syntax:

MID( text, start_num, num_chars )

Where,

  • text –Text String
  • start_num – An integer that specifies the position of the first character
  • num_chars – An integer that specifies the number of characters to be returned (starting from start_num)

 

Substring using MID Function in Excel – Example:

Formula

MID Function in Excel 1

  • In Row number 2, MID Function takes the string argument, position of the first character (6) and length of the substring (10), which means starting from 5th position 10 characters are returned so the resultant substring will be “Larry-USA”.
Result

MID Function in Excel 2

NOTE: #VALUE! – Error Occurs if

  • the supplied start_num argument is < 1;
  • the supplied num_chars argument is < 0.

previous-small MID Function in Excel                                                                                                                next_small MID Function in Excel