COMPUTER COURSES

Using LEFT, RIGHT in Excel

Excel

Description

LEFT returns the first character or characters in a text string, based on the number of characters you specify.

LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.

See more Functions

IMPORTANT: LEFTB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LEFTB behaves the same as LEFT, counting 1 byte per character.

The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.

Syntax

  • LEFT(text, [num_chars])
  • LEFTB(text, [num_bytes])

The function syntax has the following arguments:

  • Text    Required. The text string that contains the characters you want to extract.
  • Num_chars    Optional. Specifies the number of characters you want LEFT to extract.

Num_chars must be greater than or equal to zero.

If num_chars is greater than the length of text, LEFT returns all of text.

If num_chars is omitted, it is assumed to be 1.

Num_bytes     Optional. Specifies the number of characters you want LEFTB to extract, based on bytes.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s