Skip to content
Excel

LEFT function in Excel

Returns the leftmost characters from a text value

=LEFT(text, [num_chars])

LEFT syntax and parameters

Two arguments, one required.

  • textstringRequired
  • num_charsnumberOptional

LEFT examples

Formulas you'll actually reuse.

  1. The three-letter region prefix from a code like NYC-10422:

    =LEFT(A2, 3)

    Result"NYC"

  2. The username part of an email — everything before the @:

    =LEFT(B2, FIND("@", B2) - 1)

    Result"maria.lopez"

LEFT in Google Sheets

Same name — your formula ports as-is.

Try LEFT in the playground

Edit the example — nothing to install.

Preloaded with the LEFT formula from Example 1 — change anything and watch it respond.

Loading the editor…

LEFT errors

What they mean — and the fixes.

  • #VALUE!

    The character count is negative — usually a FIND that came back smaller than expected; check the delimiter exists.

Related functions

More ways Excel gets this done.