LEFTB Function

Summary

The Excel LEFTB function returns a specified number of bytes from the start of a text string. That is different from LEFT, which counts characters. In older Double-Byte Character Set (DBCS) environments, some characters use 2 bytes, so a byte-based result can differ from a character-based result.

Microsoft now treats LEFTB as a legacy compatibility function. In newer Excel versions, LEFT is the preferred function, and Microsoft notes that LEFT now supports Unicode through newer compatibility behavior. So LEFTB is mainly worth learning when you are working with older files, older systems, or lessons about byte-based text handling.

This distinction matters most in workbooks built around older language and encoding rules. A visible character count and a byte count are not always the same thing, so LEFTB exists for cases where storage size mattered more than the number of characters a person sees on screen.

Syntax

=LEFTB(text, [num_bytes])

The first argument is the text to extract from. The second argument is the number of bytes to return. If you omit num_bytes, Excel uses 1. In byte-based languages, that can matter because one visible character may take more than one byte.

Arguments

• text - [Required] The text string or cell reference you want to extract from.
• num_bytes - [Optional] The number of bytes to return from the left side. The default is 1.

LEFTB vs LEFT

The difference is simple: LEFT counts characters, while LEFTB counts bytes. For plain single-byte text like "ABC", the two functions usually give the same result. For full-width or DBCS text, they may return different results.

When LEFTB is used on multi-byte text, Excel returns whole characters only. If the requested byte count would cut through the middle of a character, Excel does not return half of that character.

Using LEFTB

LEFTB appears mainly in legacy spreadsheets that were designed around byte limits instead of character limits. For example, an older export file may allow only a fixed number of bytes in a field. In that case, LEFTB can trim the text to the allowed byte width before export.

In modern workbooks, LEFT is usually the better first choice. Use LEFTB only when the requirement is specifically about bytes, not just visible characters.

• Use LEFTB when an old workflow measures text width in bytes.
• Use LEFT when you simply need the first characters of a string.
• Be careful when mixing single-byte and double-byte characters, because the result may not match a character count.

Example 1 - Extracting Bytes from Plain Text

With plain ASCII text, each character is effectively counted one byte at a time, so LEFTB behaves much like LEFT. Asking for 3 bytes from "ABC" returns the whole string.

=LEFTB(A1, 3) // Returns "ABC"

Example 2 - Extracting Full-Width Characters

This example shows why LEFTB exists. In full-width text, one visible character can take 2 bytes. So a byte count of 2 returns only the first full-width character, not two characters.

=LEFTB(A2, 2) // Returns one full-width character

Example 3 - Returning a Prefix from Japanese Text

In Japanese text, LEFTB follows the byte count rather than the character count. If each character uses 2 bytes in the DBCS context, asking for 4 bytes returns the first two characters.

=LEFTB(A3, 4) // Returns the first 2 Japanese characters

Example 4 - Using a Byte Count from a Cell

The byte count does not need to be typed directly into the formula. You can store it in a cell and let the formula read it. That makes the extraction rule easier to adjust later.

=LEFTB("ABCDEFGHI", A4) // If A4 is 5, returns "ABCDE"

The main thing to remember is that LEFTB is not the normal choice in modern Excel work. It exists for compatibility with byte-based text handling. If your task is about visible characters, use LEFT. If your task is about byte limits in older DBCS-style workflows, LEFTB may still be relevant.

Conclusion Recap

LEFTB is the byte-based version of LEFT, so it matters mostly in older workflows where field limits were measured in bytes instead of visible characters. This lesson showed that for plain text it may look the same as LEFT, but for double-byte text the result can be different.

The main beginner takeaway is simple: in modern Excel work, LEFT is usually the right choice. LEFTB is mostly for compatibility with older systems or older files where byte count is the real rule, not character count.

• Summary: LEFTB returns text from the left side based on bytes, not characters.
• Syntax: =LEFTB(text, [num_bytes]).
• Key point: LEFTB is mainly a legacy compatibility function.
• Practical usage: Older exports, older systems, and byte-limited text fields.
• Best rule: Use LEFT for modern character-based work, and LEFTB only when byte counting is the real requirement.