Excel - The LEFT function

June 2017


[Excel] The LEFT function

Description


This function allows you to retrieve a sub-string (set of characters) from a string. Beginning from the left hand side.

Syntax


LEFT( cell/text, num_of_characters )

Implementation

  • Consider A2 contains "ccm".
  • Then
    =Left(A2, 5)
  • Will return "kiosk".

Related


Published by deri58. Latest update on November 21, 2011 at 12:11 PM by deri58.
This document, titled "Excel - The LEFT function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).