Wednesday, November 27

Tag: how to use excel mid function

MID Function In Excel

MID Function In Excel

FORMULAS, Text
MID function in excel is text function which is used to find out strings from any mid part of the sentence in excel. Mid function require the cell reference from which the text need to be extract, start number from which character need to be start , and number of character which need to be extract. NOTE: This function count the space too. So in the result it will include a space too. FORMULA: =MID(B2,7,4)