Google Sheets LEFTB Function: Syntax, Examples & Tips

string:
The text string from which you want to extract the leftmost characters based on the specified number of bytes.

num_of_bytes:
The number of bytes to extract from the left side of the string. This determines how many characters will be returned, with each character potentially counting as one or more bytes depending on the character encoding.

What is a LEFTB Google Sheets Formula?

The LEFTB function in Google Sheets is a text function that allows you to extract a specified number of bytes from the beginning of a text string. This function is particularly useful when dealing with multi-byte character sets, such as those used in languages like Chinese, Japanese, and Korean. Unlike the LEFT function, which counts characters, LEFTB counts bytes, making it more suitable for certain applications.

In simpler terms, LEFTB lets you pull out a specific number of bytes from the start of a text string, which can be essential for handling text in different languages or when working with binary data.

A Practical Example

Imagine you are working with a dataset that includes product codes, and you need to extract the first few bytes for analysis:

Product Codes Table:

You want to extract the first 4 bytes from each product code.

LEFTB Formula

To achieve this, you would use the LEFTB function as follows:

=LEFTB(A2, 4)

In this formula:

• A2 is the cell containing the ProductCode from the Product Codes Table.
• 4 is the number of bytes you want to extract from the beginning of the text string.

Result of the Formula

When you apply the LEFTB formula to the Product Codes Table, the output would look like this:

In this case, the LEFTB function extracts the first 4 bytes from each product code, which is particularly useful for the multi-byte characters in the second row.

Why Use LEFTB?

LEFTB is beneficial because it provides a way to accurately handle text strings that contain multi-byte characters. This function simplifies the process of extracting specific portions of text without worrying about character count, making it ideal for data manipulation in various languages.

Key Takeaways:

• LEFTB: A Google Sheets function that extracts a specified number of bytes from the beginning of a text string.
• Byte Count: Counts bytes instead of characters, making it suitable for multi-byte character sets.
• Data Handling: Useful for text manipulation in different languages and binary data processing.
• Common Use Cases: Ideal for extracting portions of product codes, handling international text, and working with byte-level data.

LEFTB is an essential function for anyone working with text data in Google Sheets, providing a powerful way to enhance data analysis and processing capabilities.

Happy spreadsheeting!