Excel - The LEFT function

October 2017

[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".
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).