Skip to Content

LEFTB

Returns the specified number of characters from the start of a text string, based on the number of bytes

Syntax

LEFTB(text, [num_bytes])

Parameters

  • text: Required. The text string that contains the characters you want to extract
  • num_bytes: Optional. The number of bytes to extract (default 1)

Example

=LEFTB("Sale Price", 4)
Returns: StringSince: Excel 2003