MID function is used to take the character in the string / cell address. Formula / basic formula of the MID function is ... ..
= MID (string, x1, x2) / / = MID (cell address, x1, x2) or
= MID (string: x1: x2) / / = MID (cell address; x1: x2)
information
String: words / strings, or cells that would have taken his character
x1: starting from a character string is taken to x1
x2: the number of characters taken from the left
For example:
= MID ("Yogyakarta", 5, 4) - Enter - result: root
The illustrations as shown below
0 comments:
Post a Comment