Excel function (chapter mid)

There is mid function of the function that manipulates character strings in Excel.
The mid function is a function of acquiring the character for a few minutes of the character specified from the place that the character string specified and displaying it.
【 format 】
“= mid (position where object cell and character string are begun extraction and extracted number of characters)”
【 explanation of parameter 】
The cell: The place (cell) where the character string to be extracted is specified is specified.
The position where the character string is begun the extraction: It is number of characters in which specification is extracted as for the position from the left side of the heading character of the character to be extracted from the character string specified by “Cell”: The number of characters of characters to be extracted is specified.
【 usage example 】
=mid(C1,5,2)
【 explanation of usage example 】
For instance, it is assumed that the character “Character for the extraction” is input to cell C1. It extracts it for two characters from the fifth character in the left side of the character string. Therefore, the character string two characters’ worth of “Character” will be extracted from “Sentence” of the fifth character in the left side of “Character for the extraction”.
【 notes 】
Even if the character string of all normal-width coexistence exists, it becomes an extraction for a few minutes of the character because the mid function is extracted by each number of characters.
For instance, when it is assumed that there was a character string of “AaBbCcDdEe” on cell C1, and specifies the function of “=mid(C1,5,2) “, two characters of “Cc” will be extracted.
There is “Midb function” to divide em-size and normal-width. The character of “bC” will be extracted for “=mid(C1,6,3)” when going by the character string ahead because it becomes a thing of em-size = two byte and normal-width = one byte because this is not a number of characters and becomes an extraction by the number of bytes.