:Table text function: Use the LEFTB function to extract the number of bytes-Table skills免费ppt模版下载-道格办公

Table text function: Use the LEFTB function to extract the number of bytes

Picture and text skills
Case

LEFTB Returns the first character or characters in a text string based on the number of bytes specified. This function works with double-byte characters.

Syntax
LEFTB(text,num_bytes)
Text is the text string containing the characters to be extracted.
Num_bytes is specified by the number of bytes extracted by LEFTB number of characters.
￭< /span>Num_bytes must be greater than or equal to 0.
￭< /span> If Num_bytes is greater than the text length, LEFT returns all text.
￭< /span>If Num_bytes is omitted, it is assumed to be 1.

When we are making When creating employee salary tables, you often need to use the LEFTB function. The LEFTB function extracts a specified number of bytes from the beginning of a string.
Give an example to help everyone understand better.

￭ In this employee salary table, we select cell (B7).
Select the insertion function. Here we need to fill in two values, the string and the number of bytes.
String is the string text that needs to be extracted, and the number of bytes is the number of strings to be extracted.

￭ Let's take Xiao Ming's salary as an example, select the cell (B3) at the string position, and select 4 as the number of bytes.
Click OK and the results will come out!

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-qiao-yong-LEFTB-han-shu-ti-qu-zi-jie-ge-shu.html