Table of Contents
The LEFTB function in Google Sheets is a useful tool for extracting a specific number of characters from the beginning of a text string in a cell. This function is particularly helpful for handling texts with double-byte characters, such as Japanese or Chinese characters. To use the LEFTB function, simply enter the cell reference and the number of characters you want to extract. This function can be applied in various scenarios, such as sorting data or creating customized labels. Overall, the LEFTB function in Google Sheets offers a convenient and efficient way to manipulate text data.
LEFTB function
The LEFTB function returns the left portion of a string up to a certain number of bytes.
Parts of a LEFTB function
LEFTB(string, num_of_bytes)
| Part | Description |
string | The string from which the left portion will be returned. |
num_of_bytes | (Optional) The number of bytes to return from the left side of `string`. |
Notes
LEFTBreturns the same value asLEFTif the input string has only single byte charactersnum_of_bytesmust be greater than or equal to zero.- If
num_of_bytesis greater than the length of text in bytes,LEFTBreturns all of text. - If
num_of_bytesis omitted, it is assumed to be 1.
Examples
| A | B | C | |
| 1 | Input | Formula | Output |
| 2 | Aeñ | =LEFTB(A2, 2) | Ae |
| 3 | Aeñ | =LEFT(A3,2) | Ae |
| 4 | 熊本 | =LEFTB(A4, 2) | 熊 |
| 5 | 熊本 | =LEFT(A5,2) | 熊本 |
Related functions
- MIDB: The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.
- RIGHTB: The RIGHTB function returns the right portion of a string up to a certain number of bytes.
- LENB: The LENB function returns the length of a string in bytes.
Cite this article
stats writer (2024). .How do I use the LEFTB function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-leftb-function-in-google-sheets/
stats writer. ".How do I use the LEFTB function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-leftb-function-in-google-sheets/.
stats writer. ".How do I use the LEFTB function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-leftb-function-in-google-sheets/.
stats writer (2024) '.How do I use the LEFTB function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-leftb-function-in-google-sheets/.
[1] stats writer, ".How do I use the LEFTB function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. .How do I use the LEFTB function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.