LEFTB

Returns leftmost bytes from text.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Text

Examples

=LEFTB("spreadsheet", 6)

Result spread

Syntax

LEFTB(text, [num_bytes])

text: text required
num_bytes: number optional defaults to 1

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.