Formulas > =LEFTB()

How To Use LEFTB() Function in Google Sheets


Returns the left portion of a string up to a certain number of bytes.

Common questions about the LEFTB formula include:
-What does the LEFTB formula do? 
-What are the limitations of LEFTB?
-How do I use LEFTB with text strings?

The LEFTB formula can be used to extract text from a cell, starting from the leftmost character. It takes two arguments and returns a specified number of characters from the start of the text string.

The LEFTB formula can be easily mistyped as LEFT or LB instead of LEFTB.

Common ways the LEFTB formula is used inappropriately include not defining the arguments correctly, not specifying the number of characters to be returned, and not defining the text string correctly.

Common pitfalls when using the LEFTB formula include confusion between the leftmost character and the specified number of characters, not accounting for spaces when specifying the arguments, and trying to return text from multiple cells at once.

Common mistakes when using the LEFTB Formula include forgetting to include the starting quotation mark, not using the correct number of arguments, and not entering the correct value in the provided arguments.

Common misconceptions people may have with the LEFTB Formula include misunderstanding the specified number of characters argument and assuming the formula can be used to return text from multiple cells at once.

How To Actually Use LEFTB() in Sheets

LEFTB(string, num_of_bytes)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the LEFTB() formula:


By Rachel Hanson and Sam Lee

Generate a LEFTB() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.