<div class="raw-html-embed"><p>The <b>MID/MIDB</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to extract the characters from the specified string starting from any position. The <b>MID</b> function is intended for languages that use the single-byte character set (SBCS), while <b>MIDB</b> - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.</p>

<h5 class="pt8">Syntax</h5>
<p><b><em>MID(text, start_num, num_chars)</em></b></p>
<p>The <b>MID</b> function has the following arguments:</p>
<table style="width: 40%">
    <tbody>
        <tr>
            <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
            <th style="background-color: #f4f4f4"><b>Description</b></th>
        </tr>
        <tr>
            <td><b><em>text</em></b></td>
            <td>A string you need to extract the characters from.</td>
        </tr>
        <tr>
            <td><b><em>start_num</em></b></td>
            <td>A position you need to start extracting from.</td>
        </tr>
        <tr>
            <td><b><em>num_chars</em></b></td>
            <td>A number of the characters you need to extract.</td>
        </tr>
    </tbody>
</table>

<p><b><em>MIDB(text, start_num, num_bytes)</em></b></p>
<p>The <b>MIDB</b> function has the following arguments:</p>
<table style="width: 40%">
    <tbody>
        <tr>
            <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
            <th style="background-color: #f4f4f4"><b>Description</b></th>
        </tr>
        <tr>
            <td><b><em>text</em></b></td>
            <td>A string you need to extract the characters from.</td>
        </tr>
        <tr>
            <td><b><em>start_num</em></b></td>
            <td>A position you need to start extracting from.</td>
        </tr>
        <tr>
            <td><b><em>num_bytes</em></b></td>
            <td>A number of the characters you need to extract, based on bytes.</td>
        </tr>
    </tbody>
</table>

<h5 class="pt8">Notes</h5>
<p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>MID/MIDB</b> function.</p>

<h5 class="pt8">Examples</h5>
<p>The figure below displays the result returned by the <b>MID</b> function.</p>
<p><img alt="MID Function" src="https://static-helpcenter.teamlab.info/mid_1dd03cfdaa.png"></p></div>

MID Function

Docs

Argument	Description
*text*	A string you need to extract the characters from.
*start_num*	A position you need to start extracting from.
*num_chars*	A number of the characters you need to extract.

Argument	Description
*text*	A string you need to extract the characters from.
*start_num*	A position you need to start extracting from.
*num_bytes*	A number of the characters you need to extract, based on bytes.

MID Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud