Excel - The LEFT function

October 2016

[Excel] The LEFT function


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


LEFT( cell/text, num_of_characters )


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

Related :

This document entitled « Excel - The LEFT function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.