MID FUNCTION: MID function is a 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.
FIND FUNCTION : The FIND Function is used to check or return the position of a provided Cell reference text or a character. FIND function is a case sensitive.
NOTE: MID function count the space too. So in the result it will include a space too.
SYNTAX=MID(Reference Cell, Start Number / Position, Number Of Character to Extract
IMPLEMENT: In this example we have used FIND Function Within MID Function to make it dynamic. So whenever we change the find text it will return the position according to it and on that basis the MID function will return the Start position.
