LEFTB Function Explained

The LEFTB Function in Microsoft Excel returns a specific number of characters from the left side of a text string. It takes two arguments: text (the text string from which to extract the characters) and num_chars (the number of characters to extract). It returns a text string.

LEFTB Function Syntax

LEFTB(text,num_bytes)

  • text: The text string from which the leftmost characters are returned.
  • num_bytes: The number of bytes to be returned from the leftmost side of the text string.