What does the LEFT function return in Excel?

Microsoft Excel Medium

Microsoft Excel — Medium

What does the LEFT function return in Excel?

Key points

  • The LEFT function operates on text strings, not cell ranges or alignments.
  • It requires two arguments: the text string and the number of characters to extract.
  • The function is often used with other string functions for data manipulation.
  • The extracted characters are always from the beginning of the string.

Ready to go further?

Related questions