<div class="raw-html-embed">    <p>The <b>LEFT/LEFTB</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 substring from the specified string starting from the left character. The <b>LEFT</b> function is intended for languages that use the single-byte character set (SBCS), while <b>LEFTB</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>LEFT(text, [num_chars])</em></b></p>
    <p>The <b>LEFT</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 substring from.</td>
            </tr>
            <tr>
                <td><b><em>num_chars</em></b></td>
                <td>A number of the substring characters. It must be greater than or equal to 0. It is an optional argument. If it is omitted, the function will assume it to be 1.</td>
            </tr>
        </tbody>
    </table>

    <p><b><em>LEFTB(text, [num_bytes])</em></b></p>
    <p>The <b>LEFTB</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 substring from.</td>
            </tr>
            <tr>
                <td><b><em>num_bytes</em></b></td>
                <td>A number of the substring characters, based on bytes. It is an optional argument.</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>LEFT/LEFTB</b> function.</p>

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

LEFT Function

Docs

Argument	Description
*text*	A string you need to extract the substring from.
*num_chars*	A number of the substring characters. It must be greater than or equal to 0. It is an optional argument. If it is omitted, the function will assume it to be 1.

Argument	Description
*text*	A string you need to extract the substring from.
*num_bytes*	A number of the substring characters, based on bytes. It is an optional argument.

LEFT Function

Syntax

Notes

Examples

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