Tag: excel formula with examples

Mar172020 by excelhelp13No Comments

LEN Function In Excel

FORMULAS, Text

LEN function determine the total length of a string, word, number, or sentence available in excel cell. Please note that it also count the space between the string, words, number or sentence.Please see example below in image. FORMULA: =LEN(A2)

Mar162020 by excelhelp13No Comments

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)