Some Formulas in ms.excel
It will extract the number of characters which we specify from a position which we give
Syntax: = MID ( text, start_num, num_chars )
Text: is the cell reference or the text or a string
Start_num: is the
: As the function name indicates, it will extract position from where excel has to consider
Num_ chars: is the number which you want to extract
the number of characters
from left of
the reference given
Syntax: = LEFT ( text, [ num_chars ] )
Text: is the cell reference or the text
Num_chars: is the number which you want to extract
It extracts the specified number of characters from right side of reference given.
Syntax: = RIGHT ( text, [ num_chars ] )
Text: is the cell reference or the text
Num_chars: is the number which you want to extract